Native SQL error: 'Ora 911 error'

[Former Member]

Hi,

I have written the below native SQL, but getting an error as 'An SQL error has occurred: ORA-00911: invalid character'.

If anyone knows what is wrong written here, please revert back.

EXEC SQL.

select Alias_type_id

from ALIAS@DBL_TEST.YY.XXX.COM

into :l_type_id

where ALIAS_TYPE_ID = 'XXXS'

and NAME = 'XXXS17267965-ADB';

ENDEXEC.

When the query was ended with '.' instead of ';', then I was getting ORA-00933 error.

Thanks,

Ipsita

[Former Member]

Try:

EXEC SQL.
  select Alias_type_id
    from ALIAS@DBL_TEST.YY.XXX.COM
    into :l_type_id
    where ALIAS_TYPE_ID = 'XXXS'
      and NAME = 'XXXS17267965-ADB'
ENDEXEC.

Rob

[Former Member]

Rob,

I have also tried this option, but it also gives error ORA-00933

[Former Member]

Check this SAP note : 157907 , 723149

From Note 723149 :

Errors such as ORA-00903, ORA-00911 and ORA-00953 may be triggered when objects that contain special characters are not enclosed in double quotation marks, for example:

[Former Member]

Thanks all for taking me in the right way