A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
video training course this week in the
JDBC and Relational Databases
Nested Table collection type with Blob Attributes
Joined: Jun 30, 2005
Feb 06, 2006 12:34:00
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.
It is sorta covered in the
JavaRanch Style Guide
subject: Nested Table collection type with Blob Attributes
Problems with Blob field legnth in MySql
Inheritance in Persistence
how to write BLOB type of data from java application into an oracle table
Blob to float conversion
Convertion of string object to BLOB
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015