Also look up the bind_param_inout method if your stored procedure uses an out parameter.
-----Original Message----- From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 7:48 AM To: 'Ronnie Cruickshank'; [EMAIL PROTECTED] Subject: RE: Running Stored Queries look for stored procedures in the perl docs. Here is an example. $sth_tbs_mode = $dbh->prepare("BEGIN SCOTT.BACKUP.BEGIN_BK(?); END;"); where Scott is the owner of the package. the package name is backup and the procedure is begin_bk. Thanks, Sam Gold -----Original Message----- From: Ronnie Cruickshank [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 5:46 AM To: [EMAIL PROTECTED] Subject: Running Stored Queries 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? Thanks in anticipation, Ronnie Cruickshank
