Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: How to insert a file into a CLOB object?

by kennethk (Abbot)
on Sep 04, 2013 at 15:42 UTC ( #1052380=note: print w/ replies, xml ) Need Help??


in reply to How to insert a file into a CLOB object?

See Simple_Usage in DBD::Oracle. From the link:

$sth->bind_param($field_num, $lob_value, { ora_type => ORA_CLOB });
after
use DBD::Oracle qw(:ora_types);
to import ORA_CLOB. There seems to be some conflicting data with regards to using SQLT_CHR instead, but I've successfully used the above.

#11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.


Comment on Re: How to insert a file into a CLOB object?
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1052380]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2015-07-31 00:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (274 votes), past polls