selectblob returns error ORA-00936 missing expression

[oke09081]

I am trying to do a simple select of a blob field using powerscript and am getting a return error code of -1 with the error message ORA-00936 missing expression. I am using PB 10.2.0 and Oracle 10.1.2.

blob lbl_pdffile

SELECTBLOB pdffile
into :lbl_pdffile
from pdf_files
where file_id = 1;

Anyone have any ideas why I am getting this error.

 

[thekl0wn]

After the WHERE clause (and before the semicolon), you need a USING statement. If you have custom transaction objects setup, then it will be: USING Custom_Trans ; If you're using SQLCA then it will simply be: USING SQLCA ;

 

[oke09081]

I added the using statement after the where clause but still get the same Oracle error.