• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling procedure that returns cursor AND other data

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

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?

Thanks
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic