SAP Knowledge Base Article - Preview

2928825 - Error 102 or 7332 is recorded when executing stored proc by PreparedStatement - SDK for SAP ASE

Symptom

  • A stored procedure is executed by using java.sql.PreparedStatement and DYNAMIC_PREPARE connection property is true.
  • Even though the stored procedure is done successfully and the client application does not raise any error, you may see a 102 error or a 7332 error in audit records.
  • You will also see a 102 error or a 7332 error when you trace communication between ASE and the client application by Ribo.

Error 102, Severity 15, State 181
Incorrect syntax near '<procedure name>'.

Error 7332, Severity 15, State 1
The untyped variable ? is allowed only in in a WHERE clause or the SET clause of an UPDATE statement or the VALUES list of an INSERT statement


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • jConnect
    • JDBC 7.x
    • JDBC 16.0

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

DYNAMIC_PREPARE, PreparedStatement, jconn4, jconn4.jar , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.