in reply to Calling Stored Procedure using DBI/DBD::DB2 on perl
The error sounds like the one I got all the time, trying to create an SQL procedure, because I used a ; to end the entire create procedure statement, and also internally in the procedure to end code lines, which doesnt work.
Can you call the procedure from the db2 command line with parameters, etc? Also, try printing the contents of $sql after you have created it, and make sure it contains what you think.
C.
|
|---|