Update Blob column failed
Hi,
I have two table with Blob column to store image. One table was crated in Oracle8i and migated to Oracle10g, another table was created in Oracle10g. The powerbuilder(version 10.5) code is same except the table name and the column name.
Now I use Oracle10g as the database server. The front end development tool is PowerBuilder (version 10.5)
When I try to update the image, the blob data in the first table ( created in oracle8) was updated correctly, but the same update blob statemant got ORA-00911 (Invalid character error ) against on the second table ( created in oracle 10g)
The NLS_CHARACTERSET on oracle10g and oracle8i are all US7ASCII.
Thanks for your help!!
Happy New Year 2008!!!