• Post Reply Bookmark Topic Watch Topic
  • New Topic

Calling procedure that returns cursor AND other data  RSS feed

Greg Triant
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I need to implement a call to a procedure via JDBC that returns a cursor and some other data. The output of the procedure looks like this:

{Varchar2 v, Cursor c {Varchar v, Number n}, Intreger i}

- My first question is, what is the correct way to call the procedure. I know that the input is varchar and the ouput is as described above.
I suppose I need sth different than:

{ ? = call pkg.proc_name( ? ) }

- Then I know I should handle the cursor as a result set, but how can I access all of the output after the call is made?

It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!