Call RFC from PL / SQL

[Former Member]

Hi Everybody, i have the next question:

Its Possible from PL / SQL, call RFC Functions?...

Please can you give me some examples or tell me if is technicaly impossible to do that?..

Thanks a lot.

Greattings

Wilmer Figueroa

[Former Member]

In sqlserver 2005 with feature pack sap data provider, you may call rfc func in ssis script or writing a .NET program against the provider directly.

eg:

BAPI Execution:

Exec BAPI_CREDITCARD_CHECKNUMBER

@CREDITCARD_TYPE='VISA',

@CREDITCARD_NUMBER='4346764526349895’

RFC Call:

Exec RFC_CUSTOMER_GET @NAME1 ='*'

Query Table:

select top 1000 AUGDT as clearing_date, BELNR as document_number, KUNNR as customer_number, BUZEI as line_item, GJAHR as fiscal_year from BSEG

http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&Displa...

[former_member583013]

I don't think you can do it...PL/SQL is a database language...So you don't have any API to make the connection...

Greetings,

Blag.