on ‎2022 Jan 26 4:46 PM
My Procedure is something like :
PROCEDURE SAMPLE(
IN EMP_DATA COM_SAP_EMP,
IN ID INTEGER,
IN AGE INTEGER,
OUT RESULT TABLE("ABC" NVARCHAR(10),
"DEF" NVARCHAR(10),
"GHI" NVARCHAR(20))
) READS SQL DATA AS
BEGIN
I need to call it from my CAP Java project but couldn't
find any, how can i get the result out of the execution of this procedure,
as to get that we have to register the out parameter as below:
callableStatement.registerOutParameter("RESULT", Types.???);
Here I had tried with what all possible values of Types.__ available.
Request clarification before answering.
Hi Arun, Have you find any solution for this problem ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.