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.07
- 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, prepared statement, prepare, dyn, , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.