02-27-2017 11:56 AM
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
02-27-2017 12:01 PM
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),
02-27-2017 12:37 PM
Could you post code of any of your try, also be sure to read EXEC SQL - EXECUTE.
02-27-2017 4:41 PM
02-28-2017 5:36 AM
02-28-2017 5:47 AM
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