XP is just a number | |
PerlMonks |
Re^2: Oracle BLOB Locatorby Lhamo Latso (Scribe) |
on Aug 20, 2005 at 17:51 UTC ( [id://485404]=note: print w/replies, xml ) | Need Help?? |
The first error listed occurs on the subsequent sth2.bind_param with:
and the second error occurs on the sth2.execute with: I think the second one in more correct, being that I actually could do the bind. The PLS-00306 error occurs on the sth2.execute statement, during the call to dbms_lob.filegetname. The first passed arguement is the lob locator, of which DBD::Oracle provides 2 ora_types: ora_clob and ora_blob. My lob locator is BFILE. I worked later last night and found that the Oracle column IDs CLOB, BLOB and BFILE are 112, 113 and 114. That makes the error message accurate in that I gave the wrong type. I tried just passing an integer 114, but the DBD or DBI interface complained and replaced it with SQLVARCHAR. I just checked the code. I had "use strict;" on. Thanks for the help.
In Section
Seekers of Perl Wisdom
|
|