02-02-2010 1:22 PM
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
02-02-2010 2:36 PM
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
02-02-2010 2:36 PM
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
02-02-2010 3:53 PM
Rob,
I have also tried this option, but it also gives error ORA-00933
02-02-2010 8:29 PM
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:
02-11-2010 12:06 PM