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),
Could you post code of any of your try, also be sure to read EXEC SQL - EXECUTE.
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
Add comment