A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Datatype issue while calling a Stored procedure from Groovy
Joined: Sep 24, 2010
Mar 20, 2013 17:20:40
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:
subject: Datatype issue while calling a Stored procedure from Groovy
Non supported character set: oracle-character-set-178
Invalid number error
Stored Procedure - Array
How to use IN OUT parameter
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015