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
Author

Call an Oracle package

Manuel Leiria
Ranch Hand

Joined: Jul 13, 2007
Posts: 171
Hi,

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
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8


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

OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
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