wood burning stoves 2.0*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 753
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: 19656
    
  18

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: wrong number of type of argument while calling oracle procedure from java.
 
Similar Threads
simpleJdbcCall , org.springframework.jdbc.BadSqlGrammarException
What is wrong with this procedure?
RemoveException(): Illegal attempt to remove a stateful session bean...
Call an Oracle package
NamedStoredProcedureQuery gets no result