I think you have to try this instead:
$sth=$dbh->do("BEGIN index_reporting.index_report($pass) END";);
or explicitly like this:
$sth=$dbh->prepare("BEGIN index_reporting.index_report(:1) END";);
$sth->bind_param($pass);
$sth->execute();
-----Original Message-----
From: Stan Brown [mailto:[EMAIL PROTECTED]]
Sent: donderdag 29 november 2001 14:02
To: [EMAIL PROTECTED]
Subject: How to execute an Oracle PLSQL procedure with dbi?
OK, this sounded simple, but I must be doing soemthing wrong.
I have a PLSQL procedure whch I can execute sucsefully from the SqlPLus
command line as follows:
execute index_reporting.index_report(1)
So, I thought I could simple do this in my perl script:
$dbh->do("execute index_reporting.index_report($pass)");
But that does not work.
So what am I doing wrong?
--
Stan Brown [EMAIL PROTECTED]
843-745-3154
Charleston SC.
--
Windows 98: n.
useless extension to a minor patch release for 32-bit extensions and
a graphical shell for a 16-bit patch to an 8-bit operating system
originally coded for a 4-bit microprocessor, written by a 2-bit
company that can't stand for 1 bit of competition.
-
(c) 2000 Stan Brown. Redistribution via the Microsoft Network is
prohibited.
**** DISCLAIMER ****
"This e-mail and any attachment thereto may contain information which is confidential
and/or protected by intellectual property rights and are intended for the sole use of
the recipient(s) named above.
Any use of the information contained herein (including, but not limited to, total or
partial reproduction, communication or distribution in any form) by other persons than
the designated recipient(s) is prohibited.
If you have received this e-mail in error, please notify the sender either by
telephone or by e-mail and delete the material from any computer".
Thank you for your cooperation.
For further information about Proximus mobile phone services please see our website at
http://www.proximus.be or refer to any Proximus agent.
