cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP DBTech JDBC: Cannot convert SQL type TABLE to Java type java.lang.Object.

arungupta0374
Associate
Associate
0 Likes
2,553
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.
View Entire Topic
sunil_111k80
Discoverer

Hi Arun, Have you find any solution for this problem ?