File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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 :
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: 32819

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:
subject: error in Oracle function
It's not a secret anymore!