This week's book giveaway is in the Agile forum.
We're giving away four copies of The Software Craftsman and have Sandro Mancuso on-line!
See this thread for details.
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


Win a copy of The Software Craftsman this week in the Agile forum!
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?
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: Datatype issue while calling a Stored procedure from Groovy