On Fri, 27 Jun 2003 10:45:42 +0100 Ronnie Cruickshank <[EMAIL PROTECTED]> wrote:
> Can anyone tell me if DBI can run Oracle stored procedures and if > so how? I'm not familiar with Oracle but I have a requirement to > write a script which will be ran in a UNIX cron. This script will run a > querie that is part of a package which is stored on the Oracle DB. > The normal method of performing this is to exec q_name (q_name > being the actual querie). I've had a look in the PERL DBI manuals > index and there is no reference to "exec" there - can DBI do this in > the normal prepare/execute cycle? See the examples in the DBD::Oracle source. http://search.cpan.org/src/TIMB/DBD-Oracle-1.14/Oracle.ex/proc.pl in particular shows procedure and function calls. The fine DBD::Oracle manual (perldoc DBD::Oracle) also has examples. In SQL*Plus, EXECUTE can be used to execute single statements like procedure calls. I'm not sure where you found 'exec'. -- Mac :}) Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
