File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes wrong number of type of argument while calling oracle procedure from java. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "wrong number of type of argument while calling oracle procedure from java. " Watch "wrong number of type of argument while calling oracle procedure from java. " New topic
Author

wrong number of type of argument while calling oracle procedure from java.

Jigar Naik
Ranch Hand

Joined: Dec 12, 2006
Posts: 751
Hi,

I have written one function in oracle.



and i am trying to all this function though java as below.



but i am getting error message wrong number of argument or type. Can anybody help me out with this. the argument seems like ok. and type also seems to be ok.



Can anybody please help me out with this.


Jigar Naik


Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19543
    
  16

The function takes two parameters and returns a VARCHAR2. You call it as if the return value was a third parameter.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
 
subject: wrong number of type of argument while calling oracle procedure from java.
 
Similar Threads
RemoveException(): Illegal attempt to remove a stateful session bean...
What is wrong with this procedure?
Call an Oracle package
NamedStoredProcedureQuery gets no result
simpleJdbcCall , org.springframework.jdbc.BadSqlGrammarException