topic Native SQL error: 'Ora 911 error' in Application Development and Automation Discussions

Native SQL error: 'Ora 911 error'

Former Member — Tue, 02 Feb 2010 13:22:26 GMT

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

Re: Native SQL error: 'Ora 911 error'

Former Member — Tue, 02 Feb 2010 14:36:01 GMT

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

Re: Native SQL error: 'Ora 911 error'

Former Member — Tue, 02 Feb 2010 15:53:05 GMT

Rob,

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

Re: Native SQL error: 'Ora 911 error'

Former Member — Tue, 02 Feb 2010 20:29:53 GMT

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:

Re: Native SQL error: 'Ora 911 error'

Former Member — Thu, 11 Feb 2010 12:06:59 GMT

Thanks all for taking me in the right way