John Whitnack wrote:
I am having a problem with saving a Binary file to BLOB column in Oracle. I get a weird error message telling me that the table does not exists even though I can see it using SQLplus. He is a sample of the code I am using.
....
The exact error message I recieve is:
DBD::Oracle::st execute failed: ORA-04043: object file_table does not exist (DBD SUCCESS: OCIDescribeAny(view)/LOB refetch) at LoadFile.pl line 180.
Does anyone know what could be causing it not to see the table?
I hit this error due to the problem described here: http://groups.google.com/groups?q=Oracle+LOB+04043&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=c67657ff.0202201224.69d0d26e%40posting.google.com&rnum=2 When I fully qualified the table name (after some DBA magic maybe?) it worked. It all started when the DBA's changed the perms on our schema. Fortunately we use LOBs in more than one place so it was obvious that this was related to the change and LOBs -- only LOBs were affected. I ran across some other LOB related errors of this nature when I searched, so that may not be it for you. Try a Google search on 'Oracle LOB 04043' or something similar. -- Steve Sapovits GSI Commerce, Inc. http://www.gsicommerce.com [EMAIL PROTECTED]
