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 Call an Oracle package 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 "Call an Oracle package" Watch "Call an Oracle package" New topic

Call an Oracle package

Manuel Leiria
Ranch Hand

Joined: Jul 13, 2007
Posts: 171

I have this Oracle package:

and now I want to call the function F_DIA. I'm using this syntax (extracted from some oracle tutorial just to get it working):

and I'm getting this exception:

Any ideas?

thnaks in advance,

Manuel Leiria<br /> <br />--------------<br />Peace cannot be kept by force; it can only be achieved by understanding. <br /> Albert Einstein
Jan Cumps

Joined: Dec 20, 2006
Posts: 2491

[ May 27, 2008: Message edited by: Jan Cumps ]

OCUP UML fundamental and ITIL foundation
youtube channel
I agree. Here's the link:
subject: Call an Oracle package
Similar Threads
wrong number of type of argument while calling oracle procedure from java.
Can a oracle Stored procedure return a cursor as a return value?
simpleJdbcCall , org.springframework.jdbc.BadSqlGrammarException
trying to get rows to ResultSet with CallableStatement and stored function
java stored procedure problems