Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
Datatype issue while calling a Stored procedure from Groovy
posted 2 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?
I agree. Here's the link:
Non supported character set: oracle-character-set-178
Invalid number error
Stored Procedure - Array
How to use IN OUT parameter