I'm having problems running  a stored procedure using the Win32::ODBC
package.  I am executing the following:

sql statement: "call BSCPROC.PHCT110 ('JAG','12345670','',.7,
'2009-05-02','2009-05-03', NULL,NULL,' ', '45','petes',?,?,?,?,?)"

and I get back the following message:

Error: "-99999[IBM][CLI Driver] CLI0100E  Wrong number of parameters.
SQLSTATE=0700110"

 

I've checked multiple times and am sending the correct number of
parameters.  The driver I am using is:

IBM DB2 ODBC DRIVER version 8.01.12.99

 

I have done some searching and tried things like setting AUTOCOMMIT off,
but no luck.

 

Has anyone seen this before?  

 

Thanks,

Peter

 

 

 

 

Peter W Schwartz

Vice-President

IB Technology - Prime Brokerage / JP Morgan Chase 

(973) 793-7407

 



This email is confidential and subject to important disclaimers and
conditions including on offers for the purchase or sale of
securities, accuracy and completeness of information, viruses,
confidentiality, legal privilege, and legal entity disclaimers,
available at http://www.jpmorgan.com/pages/disclosures/email.  
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to