Call RFC-Function from PL/SQL

[Former Member]

Hello!

I have a data set in oracle database which should be transferred to sap. I am going to implement it by creating a RFC-function and calling it from pl/sql code. Please could you give me some examples or documentation on sap-rfc and pl/sql.

Best Regards,

Maris

[Former Member]

Hey,

It is not that easy,

SAP didn't published an package to link PL/SQL to RFC,

(in the other way, it is possible to execute PL/SQL from SAP-ABAP, but it is not recommended by sap due to the fact that PL/SQL is ORACLE specific)

however, it is possible with some work:

the PL/SQL can execute command on operation system of the DB

for example 'dir' in windows or 'ls' in unix,

instead of running dir/ls you can execute a program that will execute an RFC in the SAP system.

the program can be developed by .Net connector, see: