This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
internet detective

Joined: May 26, 2003
Posts: 30136

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

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: error in Oracle function
Similar Threads
Urgent need help with PL/SQL function
Oracle Procedure through Java
problem with my procedure
pl/sql error
Passing multiple values to a stored procedure