I have the following updateblob statment in a NVO function, but it will not update a blob field in an Oracle 9 table:
updateblob WPST.STATIC_FILE
set FILE_CONTENT = :i_blb_filedata
where ROW_ID = :li_row_id using SQLCA;
if SQLCA.sqlcode < 0 then
messagebox('ERROR', 'Error updating blob: ' + SQLCA.sqlerrtext)
end if
When I go back to the table to look at the field it is zero length. I do not get any errors back. The statement commits without throwing back an error.
I know the blob, i_blb_filedata, has content, because when I do a length check on the variable content it comes back as 72. And also I looked at the text the blob contains through a messagebox, just before calling updateblob.
In the Oracle table the field, File_content, which i_blb_filedata is to be assigned to is defined as capable of being NULL, and it has not default.
The variable, i_blb_filedata, is declared as an instance variable,
because the function where it is used is separate from the function it is created in.
The Oracle blob field or updateblob is not accepting i_blb_filedata for whatever reason.
I am using Powerbuilder 9.
getjbb
updateblob WPST.STATIC_FILE
set FILE_CONTENT = :i_blb_filedata
where ROW_ID = :li_row_id using SQLCA;
if SQLCA.sqlcode < 0 then
messagebox('ERROR', 'Error updating blob: ' + SQLCA.sqlerrtext)
end if
When I go back to the table to look at the field it is zero length. I do not get any errors back. The statement commits without throwing back an error.
I know the blob, i_blb_filedata, has content, because when I do a length check on the variable content it comes back as 72. And also I looked at the text the blob contains through a messagebox, just before calling updateblob.
In the Oracle table the field, File_content, which i_blb_filedata is to be assigned to is defined as capable of being NULL, and it has not default.
The variable, i_blb_filedata, is declared as an instance variable,
because the function where it is used is separate from the function it is created in.
The Oracle blob field or updateblob is not accepting i_blb_filedata for whatever reason.
I am using Powerbuilder 9.
getjbb