Register / Login
Datatype issue while calling a Stored procedure from Groovy
posted 3 years ago
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;
Can we pass the boxIntArr in place of NUMBER_LIST?
Non supported character set: oracle-character-set-178
Invalid number error
Stored Procedure - Array
How to use IN OUT parameter