wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes error in Oracle function Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "error in Oracle function" Watch "error in Oracle function" New topic

error in Oracle function

Sharma Ashutosh

Joined: Apr 06, 2001
Posts: 346
I'm trying to use a stored procedure-a function which cud accept the array of longs and return me the resultSet.
After doing a lot of investigation on the web-i can successfully pass the array but while executing the code via SQL*Plus or Java/JDBC i m keep on getting this error:

Can someone help me what to do?

Ashutosh Sharma
SCJP 1.2, SCEA 5, Brainbench certified J2EE Developer, Documentum Certified Professional
Blog : http://scea5-passingpart2and3.blogspot.com/
Sharma Ashutosh

Joined: Apr 06, 2001
Posts: 346
Got the answer-one shud declare these kind of declaration in the create/replace package
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

Thanks for posting the answer.
[ May 21, 2005: Message edited by: Jeanne Boyarsky ]

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link: http://aspose.com/file-tools
subject: error in Oracle function
jQuery in Action, 3rd edition