topic Re: Get data from oracle procedure using native sql in Application Development and Automation Discussions

Get data from oracle procedure using native sql

aneel_munawar — Mon, 27 Feb 2017 11:56:54 GMT

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

Re: Get data from oracle procedure using native sql

aneel_munawar — Mon, 27 Feb 2017 12:01:53 GMT

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),

Re: Get data from oracle procedure using native sql

RaymondGiuseppi — Mon, 27 Feb 2017 12:37:37 GMT

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

Re: Get data from oracle procedure using native sql

retired_member — Mon, 27 Feb 2017 16:41:19 GMT

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

Re: Get data from oracle procedure using native sql

aneel_munawar — Tue, 28 Feb 2017 05:36:39 GMT

Dear Raymond,

I am using this program. File is attached.

Regards,

Aneel

ztest.txt

Re: Get data from oracle procedure using native sql

aneel_munawar — Tue, 28 Feb 2017 05:47:44 GMT

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