This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • 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