| Author |
Datatype issue while calling a Stored procedure from Groovy
|
subbukumararaja chandrasekaran
Greenhorn
Joined: Sep 24, 2010
Posts: 17
|
|
Hi
I am calling a Stored Procedure that takes the input as array of numbers.
From the the Groovy side i am passing the int[] to that stored procedure.
But i am getting "Invalid Column Type" as the result from Stored Procedure.
Could somebody suggest me that how to pass a array of numbers from Groovy side?
The TYPE i created in Stored Procedure side.
create or replace TYPE NUMBER_LIST IS TABLE OF NUMBER;
The int[] in groovy is;
int[] boxIntArr = new int[5];
Can we pass the boxIntArr in place of NUMBER_LIST?
|
 |
 |
|
|
subject: Datatype issue while calling a Stored procedure from Groovy
|
|
|