Nope. The results are the same error. Could it have to do with the stored procedure having output variables?
Peter W Schwartz Vice-President IB Technology - Prime Brokerage / JP Morgan Chase (973) 793-7407 _____ From: perl-win32-users-boun...@listserv.activestate.com [mailto:perl-win32-users-boun...@listserv.activestate.com] On Behalf Of Paul Rogers Sent: Wednesday, May 06, 2009 2:44 PM To: perl-win32-users@listserv.ActiveState.com Subject: RE: Win32::ODBC I'd suggest you strongly consider switching to DBI/DBD::ODBC (1.21). Win32::ODBC is obfuscated. Try with DBI/DBD::ODBC and see if results change. Paul --- From: perl-win32-users-boun...@listserv.activestate.com [mailto:perl-win32-users-boun...@listserv.activestate.com] On Behalf Of Schwartz, Peter (JPMC) Sent: Wednesday, May 06, 2009 2:25 PM To: perl-win32-users@listserv.ActiveState.com Subject: Win32::ODBC 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. 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 Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
