Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Nested Table collection type with Blob Attributes  RSS feed

 
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
Boost this thread!