RE: Syntax for executing a stored procedure?

[Kong, Alan]

Laurie,

I have a program calling stored procedure in the following way and working okay.

my $func = $dbh->prepare(q{
                   BEGIN
                 Upd_lead_time;
                   END;
}) or die $DBI::errstr;

$func->execute();

Hope this working for you also.

Alan

-----Original Message-----
From: Laurie Vien [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 1:04 PM
To: Laurie Vien; '[EMAIL PROTECTED]'
Subject: RE: Syntax for executing a stored procedure?


To clarify:  Of course, the only thing that executes correctly under SQLplus
of those 3 lines is the "EXECUTE Upd_lead_time" statement.

:-)

-----Original Message-----
From: Laurie Vien [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 1:02 PM
To: '[EMAIL PROTECTED]'
Subject: Syntax for executing a stored procedure?


I'm using DBI::ODBC.  All I want to do is execute a stored procedure, but
the 3 lines below (which execute correctly under SQLplus) result in an
"invalid SQL statement" error.  (My ODBC connection is set up to use the
Microsoft ODBC Driver for Oracle.)   What would correct syntax be?:

$sql_stmt = "EXECUTE Upd_lead_time";
$sth = $dbh->prepare($sql_stmt);
$sth->execute();        

Laurie A. Vien
Sr. Programmer/Analyst
Ben & Jerry's Homemade, Inc.
South Burlington, VT  05403