File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

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: 2501

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

OCUP UML fundamental and ITIL foundation
youtube channel
GeeCON Prague 2014
subject: Call an Oracle package