on 05-28-2019 3:01 AM
Hi all,
Currently we encounter a problem.we try to execute a oracle procedure to get a list of stock material information stored in another system. but we don't know the correct way to call a procedure that return a cursor. can anyone help out?
Thanks and best regards!
Hi,
you can use the standard framework ADBC (package SDB_ADBC) to do that. Youy can call procedures from the DB (CL_SQL_STATEMENT->EXECUTE_PROCEDURE), and process the reuslt using the class CL_SQL_RESULT_SET that support the use of cursors (mthods NEXT, NEXT_PACKAGE, CLOSE......)
You have an example in report ADBC_DEMO_PROC_CALLS_HDB:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your answer! I still wonder whether the ADBC support oracle procdure,as the demo you offer is designed for Hana Database.
Hi Tong Li,
ADBC support Oracle procedures. ADBC is an agnostic framework that support all DB supported by SAP.
The example is written for a HANA procedure, but can be use in similar way to use an Oracle procedure.
Thanks for your answer! I still wonder whether the ADBC support oracle procdure,as the demo you offer is designed for Hana Database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.