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.ja
>va:380)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.ja
>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]
