How to Call a Stored Procedure from DBD::mysql
Posted by:
ray licon
Date: January 12, 2006 04:35PM
Hello -
I'm trying to do a simple strored procedure call. The SP does not return a value. The call works from within mysql, but not from perl DBI,
The code:
my($statment) = 'CALL("CMTNCA01","","SWITCHING","ALL","mn",8,"Posting Test Message","no detail","r");';
if( $dbh = &sl_database::db_init() ){
if( $dbh->do($statement) ){
print "executed\n";
}else{
print "failed executed\n";
}
It Fails.
perl DBD::mysql 3.0002
Is there some other way to execute this? I did try a prepare then execute, which also fails.
Thanks
Ray
Subject
Written By
Posted
How to Call a Stored Procedure from DBD::mysql
January 12, 2006 04:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.