That's it! OMG, I am such a friggin' bonehead. Thanks mucho!
Kevin -----Original Message----- From: Anhaus, Thomas [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2003 1:31 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE:A little guidance with my dbproc -4024 error Kevin Wilson wrote : >These -4024 log entries are driving me absolutely mad. There is no reason >for these dbproc errors as I cannot see anywhere the dbproc is in error. I >have attached the full dbproc code and below is the error I get in the >catalina log file from tomcat. If someone (anyone) can take a look at the >info I have provided to see if they notice something strange I would >appreciate it. >[SYSTEM INFO] >SAPDB 7.3.0.34 w/ SAP's JDBC driver >SUSE 8.1 >TOMCAT 4.1.27 >[ERROR SNIPET FROM CATALINA.OUT] >com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4024]: Error > at >com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69) > at >com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763) > at >com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429) > at >com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:320) > at >com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.j a >va:380) > at >com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.j a >va:289) > at com.synfoserv.actions.CallAction.callSearch(CallAction.java:442) >[CALLING CODE FROM WEB APPLICATION] >cstmt = m_conDb.prepareCall("{call sp_call_edit(?,?,?,?,?,?,?)}"); >cstmt.setInt(1,dtc.string2Integer(sCallId,true)); >cstmt.setInt(2,dtc.string2Integer(sCompanyId,true)); >cstmt.setInt(3,dtc.string2Integer(sDivisionId,true)); >cstmt.setInt(4,dtc.string2Integer(sPersonId,true)); >cstmt.setInt(5,dtc.string2Integer(sOpportunityId,true)); >cstmt.setInt(6,dtc.string2Integer(sQuoteId,true)); >cstmt.setInt(7,dtc.string2Integer(sOrderId,true)); >cstmt.execute(); <--- THIS IS LINE 442 >[ATTACHED FILE IS THE SP_CALL_EDIT DBPROC] You didn't initialize the variable SEARCH to 0. Therefore none of your if statements is executed and no cursor 'MYCURSOR' is created. This results in error -4024. Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
