Skip to Content
0
Former Member
Feb 12, 2007 at 03:11 PM

ERROR IN ORACLE DATABASE LINK WHEN READING DATA

122 Views

Hello Masters!

I'm using database link in order to connect SAP with an external database. I set up the connection correctly through DBCO transaction and the program is connecting fine. The error arises when using the select statement, it's giving a ORA-00919: invalid function# error. Here is the code that I'm currently using, please help me find the issue if there is a syntax problem. Thanks in advance.

EXEC SQL.

CONNECT TO 'S2M'

ENDEXEC.

IF sy-subrc EQ 0.

EXEC SQL.

SELECT parent_part,

component_part,

ref_designator,

component_type,

component_quantity

FROM material_list@MTSIIQA_PRMO.US.ORACLE.COM

INTO :t_material_list

WHERE parent_part = :p_matnr.

ENDEXEC.