| 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
|
 |
 |
|
|
subject: Nested Table collection type with Blob Attributes
|
|
|
0
