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
