• Post Reply Bookmark Topic Watch Topic
  • New Topic

Call a pl/sql package that have complex arguments

 
Luk Cora
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, i need to call a stored procedure that is delcared in this way




HASH_MAP_VARRAY is a composite variable declared in this mode



on java side i want to recall this procededure but i'm unable to understand what kind of project i should pass to it
At moment i've wrote this:


but it give me error
 
Dave Tolls
Ranch Hand
Posts: 2381
25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What error is it giving?

I will say that your procedure is declared with 4 parameters, but you seem to be assigning 5 to your callable statement.
 
Luk Cora
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dave Tolls wrote:What error is it giving?

I will say that your procedure is declared with 4 parameters, but you seem to be assigning 5 to your callable statement.


Yes i was wrong reporting the procedure code.
This ii the procedure



Anyway the problem not seems to be this, the error that it retrieve is
java.sql.SQLException: ORA-03115: unsupported network datatype or representation
 
Dave Tolls
Ranch Hand
Posts: 2381
25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That error sometimes comes up if you have a mismatch between your version of Oracle and your version of the JDBC driver.
So what are the versions of each you are using?
Do they match, according to this page?
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!