topic Re: CL_SQL_STATEMENT, DDL, and DML, && not expected in Application Development and Automation Discussions

CL_SQL_STATEMENT, DDL, and DML, && not expected

Former Member — Fri, 18 Dec 2009 18:57:59 GMT

Hello Gurus,

I am trying to perform a DML operation using class CL_SQL_STATEMENT, the issue is that my SQL statement is using && to do concatenations:


DATA: SQL TYPE REF TO CL_SQL_STATEMENT,
      ERR TYPE REF TO CX_SQL_EXCEPTION.

TRY.
    CREATE OBJECT SQL.
    SQL->execute_update(
    `DELETE FROM ` && DB_OWNER && `."/BI0/AFIGL_O1000"`
   ....

and I get the following error:

"&& DB_OWNER &&" is not expected

The system is SAP_BASIS 700

I copied this code in another system SAP_BASIS 710 and I do not get the error, could it be linked to the release level of SAP_BASIS ?

Points will of course be allowed.

Regards,

Thibault

Moderator message - Please do not offer points

Edited by: Rob Burbank on Dec 18, 2009 2:29 PM

Re: CL_SQL_STATEMENT, DDL, and DML, && not expected

Former Member — Fri, 18 Dec 2009 19:31:08 GMT

My gues is that they are on two different databases (Oracle/DB2??)

Rob

Re: CL_SQL_STATEMENT, DDL, and DML, && not expected

Former Member — Fri, 18 Dec 2009 19:32:38 GMT

Hi,

No they are both on ORACLE.

Regards,

Thibault

Re: CL_SQL_STATEMENT, DDL, and DML, && not expected

prasenjit_sharma — Fri, 18 Dec 2009 20:21:09 GMT

Hi,

Can you paste the exact statement that you used to call the databse.

Regards

Prasenjit

Re: CL_SQL_STATEMENT, DDL, and DML, && not expected

prasenjit_sharma — Fri, 18 Dec 2009 21:04:50 GMT

Also try to concatenate the statement before passing to the method execute_update.

Regards

Re: CL_SQL_STATEMENT, DDL, and DML, && not expected

former_member183924 — Thu, 25 Feb 2010 10:50:41 GMT

Hi Thibault,

try something like this:

TRY.
    CREATE OBJECT SQL.

      concatenate
      `DELETE FROM '` db_owner `'`                     "#EC NOTEXT
      `."/BI0/AFIGL_O1000"`
      into sql_stmt.

    SQL->execute_update( sql_stmt ).

see FM ORA_LOG_READ for additional help.

regards,

Steffen