• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Nested Table collection type with Blob Attributes

 
meera rao
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am currently working on a solution where I need to extract a cursor of Blob datatype .

I extract the blob from the file system but do not want to store it in a table.

Instead I created an object type with Blob attributes and created a nested table.

but when I do the following, I get an error ORA-22922: nonexistent LOB value

open O_ImgCur for
SELECT ETA_ID,FILENAME FROM TABLE(CAST (IMG_FILE_OBJ AS IMG_TBL));

If I don't use a cursor and extract individual row, then I can see the blob.

Please help
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic