Kbase P115006: Execution of SQL92 stored procedure fails with error 7520
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Executing a SQL92 stored procedure with input parameters
Getting error 7520
Column not found/specified (7520)
CAUSE:
The parameters are within the literal string for the SQLIStatement as per:
SQLIStatement update_invoice = new SQLIStatement("UPDATE PUB.INVOICE SET Amount = param2, Adjustment = param3 WHERE invoicenum = param1");
FIX:
Change the SQLIStatement value to remove the parameters from within the literal string and putting them between single quotes, using following syntax:
"<literal string>" '" + param1 + "' <literal string>"