Running a SAP HANA stored procedure errors with: ‘Unterminated quoted identifier’

Symptom

Running a SAP HANA stored procedure produces the following error:

.. [HDBODBC32] Syntax error or access violation; 257 sql syntax error: unterminated quoted identifier..

Cause

The error occurs when SAP HANA identifiers are not enclosed in double quote (“) characters.

The SAP HANA ODBC layer requires that procedures are identified with double quotes, and prefixed with the schema. When the schema prefix and quoted identifiers are absent, the error will occur.

Resolution

Within the Call Procedure tool amend the procedure name so it displays in the following format:

“[schema]”.”[procedure]”

Example: Using the tool a stored procedure called PRMCSSEQPO is selected from the schema HANADB. Therefore, the display name will need to read: “HANADB”.”PRMCSSEQPO”

Before

Stored Procedure Display Name(1)

After

Stored Procedure Display Name2(1)

The following formats will not work and will return a syntax error:

PROCEDURE_NAME
“PROCEDURE_NAME”
SCHEMA_NAME.PROCEDURE_NAME