permaculture playing cards*
The moose likes JDBC and the fly likes Nested Table collection type with Blob Attributes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Nested Table collection type with Blob Attributes" Watch "Nested Table collection type with Blob Attributes" New topic
Author

Nested Table collection type with Blob Attributes

meera rao
Ranch Hand

Joined: Jun 30, 2005
Posts: 67
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Nested Table collection type with Blob Attributes
 
Similar Threads
Blob to float conversion
Problems with Blob field legnth in MySql
Inheritance in Persistence
Convertion of string object to BLOB
how to write BLOB type of data from java application into an oracle table