Executing Stored Procedures using Win32::ODBC
Quote:
> Does anyone know how to run stored procedures from Perl Win32
> using Win32::ODBC library?
> I'm currently running several web programs with Perl Win32
> but I'd like to move to executing stored procedures if possible.
Easiest and safest way is:
$Sql = " {call StoredProcName( 'text1', 'text2, numeric) } ";
$db->Sql($Sql);
...blah blah blah...
If you need to return a value...
$Sql = " {? = call StoredProcName( ... ) } ";
dave
--
================================================================
Dave Roth ...glittering prizes and
Roth Consulting endless compromises, shatter
My email address is disguised to fool automailers. Remove the
trailing 'X' to send me email.
****************************************************************
Use of this message or email address for commercial purposes
(including "junk" mailings) is strictly prohibited and protected
under current international copyright laws and United States
Code, Title 47, Chapter 5, Subchapter II.
