[JaxPM] stored procedure

[greg at turnstep.com]

On the jacksonville-pm-list; Jax.PM'er greg at turnstep.com wrote -

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> Is there a module for calling database stored procedures? I've
> looked at DBI documentation with no luck. I want to create a perl
> script that would call an Oracle stored procedure which
> inserts/updates LOB's into a table record. 

What you are looking for is the bind_param_inout() method, 
which I have used with limited success. For something that 
just does an insert/update, it will be fine, but for larger 
stored procedures, I prefer to make an external call to 
SQLPLUS via backticks and then parse through the input. 

Of course, the method is part of DBD::Oracle, which is the 
documentation you should be looking through; only the 
basic SQL statements are the same across multiple 
databases, so DBI docs only help in a general sense. The 
good news is that DBD::Oracle is an extremely well-written 
and well-supported module.

Greg Sabino Mullane
greg at turnstep.com
PGP Key: 0x14964AC8 200103300741

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iQA/AwUBOsR/M7ybkGcUlkrIEQJHQACdFqBIa44ZZW+slYpZkZy5C
MY7V8IAoMaa
oQCqy5O29wNSOBLRGvd/OIWs
=yGiD
-----END PGP SIGNATURE-----


Jax.PM Moderator's Note:
This message was posted to the Jacksonville Perl Monger's Group listserv.
The group manager can be reached at -- owner-jacksonville-pm-list at pm.org
to whom send all praises, complaints, or comments...