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.
_______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
