Urgent Help!!!... SELECTBLOB ISSUE IN PB 6.5

[Former Member]

Hi:

I am using PowerBuilder 6.5 with Oracle 11G. I get an error on SELECTBLOB from a table.

Blob    lblb_data

/*end of declaration*/

SELECTBLOB COC

INTO :lblb_data

FROM   TBLCOC

WHERE  ORDERNO = :as_order_no

AND COC is not null;

Please help!!!!.

[former_member190719]

You might want to post this over in the PowerBuilder Developer Center.

[Former Member]

Hi,

The error message says that the column is not as expected.

Do you have the table definition? For example if you do a syntax to log in the database painter what do you get?

Do you have all the necessary database rights, have you done any tracing either with TRA in the dbparm or at the Oracle side?

Ben