wood burning stoves 2.0*
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 Java 8 in Action this week in the Java 8 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: 29287
    
140

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: error in Oracle function
 
Similar Threads
problem with my procedure
Oracle Procedure through Java
Passing multiple values to a stored procedure
pl/sql error
Urgent need help with PL/SQL function