Call RFC-Function from PL/SQL

Former Member — Fri, 20 Apr 2007 09:10:08 GMT

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

Re: Call RFC-Function from PL/SQL

Former Member — Fri, 07 Sep 2007 18:28:09 GMT

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:

topic Call RFC-Function from PL/SQL in Application Development and Automation Discussions

Call RFC-Function from PL/SQL

Re: Call RFC-Function from PL/SQL