Hi,
My Perl script connects to the database(SQL Server
2000) and queries it. Also updates a column.
It works fine but now I have to do it with stored
procedures. I created the stored procedures
but am unsure of the syntax to call it from Perl
script. The procedure takes in one parameter,
a perl variable say $x.
I even tried without paramaters but in either case get
the following error.
my $query = $dbh->prepare("{call procedureName ($x)
}");
$query->execute(); # Execute SQL Query!
Error: Incorrect syntax near '{'...
I must pass parameters to the stored procedure. the
procedure exists in the database.
Any help/comments are appreciated.
Thanks,
vk
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
http://photos.yahoo.com/ph/print_splash
