File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Nested Table collection type with Blob Attributes

 
meera rao
Ranch Hand
Posts: 67
  • 0
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic