Selectblob

[lesieur]

Hello,
I'm trying retrieve an blob field in a cursor with power builder 7.
i'm using power builder 7.0.2 and oracle 8i.

Blob Document

DECLARE c_doc_blob CURSOR FOR
SELECTBLOB content
FROM EARC1P.BLOB_TABLE
WHERE EARC1P.BLOB_TABLE.PERM_ID = erm_id
ORDER BY EARC1P.BLOB_TABLE.DOCAR_ID
USING SQLARCHI;
OPEN c_doc_blob
...
when the statement 'open' execute, i'v the error:
ora24333 - zero iteration count ???

Any ideas? There is an argument to put in the dbparm? i'v try with optselectblob = 1 but it's doesn't work

 

[Lekar]

Why don't you try using a datawindow or datastore?

 

[lesieur]

Thank to respond at my question but i see in help that pb7 doesn't support the oracle blob. I try later to do this with powerbuilder 9.
My goal was to transform long raw data into blob and take the result in the cursor.

 

[royjimenez]

and if u use ONLY a SELECTBLOB with no Cursor, what happen ?

It's 'cause I've worked with images and i haven't had problems.

Let me know your results.



The life is too short to cry and long enough to try it... God bless us.