in reply to Calling Stored Procedure using DBI/DBD::DB2 on perl

Since I don't see "LE_CTRL(" anywhere in your code here, I assume its part of the procedure content?

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.

  • Comment on Re: Calling Stored Procedure using DBI/DBD::DB2 on perl