This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "error in Oracle function" Watch "error in Oracle function" New topic
Author

error in Oracle function

Sharma Ashutosh
Bartender

Joined: Apr 06, 2001
Posts: 346
Hi,
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
Bartender

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
Marshal

Joined: May 26, 2003
Posts: 30068
    
149

Monu,
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
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