File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Groovy and the fly likes Datatype issue while calling a Stored procedure from Groovy Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Languages » Groovy
Bookmark "Datatype issue while calling a Stored procedure from Groovy" Watch "Datatype issue while calling a Stored procedure from Groovy" New topic
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Datatype issue while calling a Stored procedure from Groovy
 
Similar Threads
Stored Procedure - Array
Invalid number error
stored procedure_array
Non supported character set: oracle-character-set-178
How to use IN OUT parameter