Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re^2: Oracle BLOB Locator

by Lhamo Latso (Scribe)
on Aug 20, 2005 at 17:51 UTC ( #485404=note: print w/replies, xml ) Need Help??

in reply to Re: Oracle BLOB Locator
in thread Oracle BLOB Locator

The first error listed occurs on the subsequent sth2.bind_param with:
$fil = $hashref->{IMP_IMAGE};
and the second error occurs on the sth2.execute with:
$fil = ${ $hashref->{IMP_IMAGE} };
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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://485404]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2017-11-22 00:22 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (312 votes). Check out past polls.