Hi John,
I think this may help U.
my $sth = $dbh->prepare("BEGIN procedure_name(:param-1, :param-2, :param-3,
:param-4, :param-5); END;");
$sth->bind_param(":param-1", "AAA");
$sth->bind_param(":param-2", "AAA");
$sth->bind_param(":param-3", "AAA");
$sth->bind_param_inout(":param-4", \$var-1, 10);
$sth->bind_param_inout(":param-5", \$var-2, 10);
my $rc = $sth->execute || die "Cant execute: $DBI::errstr \n";
NOTE: param-1/2/3 are input parameters and param-4/5 are output params..
If you still have any questions let me know.. :-)
regards
Prem
-----Original Message-----
From: John Saylor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 1:57 PM
To: [EMAIL PROTECTED]
Subject: calling stored procedures with DBD::Informix
Hi
I need to call a stored procedure, and I can't find the documentation
and I'm not sure I remember the syntax, so I'm writing this note in the
hope that someone will help me.
I think it's something like this:
$s = 'STORED PROCEDURE ( var1, var2 )";
$dbh->do ( $s );
With all the error checking stuff left out for brevity.
Am I right?
--
\js
Hey, just because I don't care doesn't mean I don't understand!
-- Homer tries to understand Lisa, ``Lisa's Substitute''