Get data from oracle procedure using native sql

[aneel_munawar]

Dear Abappers,

How can I get data from oracle procedure using cursor using native sql in abap.?

I have different codes but no success.

Regards,

Aneel

[aneel_munawar]

procedure has one cursor out and two parameters as in as date type.

The cursor will return following fields.

SBS_NO(100),
STORE_NO(100),
DOC_NO(100),
DOCUMENT_DATE(100),
POSTING_DATE(100),
LOC_DNAME(100),
TENDER_NAME(100),
CRD_NAME(100),
AMOUNT(100),
SALE_DISCOUNT(100),
TAX_AMOUNT(100),
TAX_RATE(100),
REFERENCE_TXT(100),
LINE_ITEM_TEXT(100),

[RaymondGiuseppi]

Could you post code of any of your try, also be sure to read EXEC SQL - EXECUTE.

[retired_member]

See https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abenadbc_procedure...

[aneel_munawar]

Dear Raymond,

I am using this program. File is attached.

Regards,

Aneel

ztest.txt

[aneel_munawar]

Dear Horst Keller,

I am using external oracle Database but not current sap oracle DB. I have connected the external DB using DBCOCKPIT option.

I have attached the text file. You can see the file above. I can get the data from table but I am facing issue when I get data from oracle procedure.

The procedure takes two date parameters and returns the dataset of columns as given in text file. But I am unable to print that returned data.

Need your help.

Thanks,

Aneel