Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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: 2110
16
  • 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: 2110
16
  • 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic