• Post Reply Bookmark Topic Watch Topic
  • New Topic

retrieve data from a stored ORACLE procedure by JSP

 
Baranenko Nikolay
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

want to resolve problem

in Oracle exits procedure witch returns SYS_REFCURSOR

REPORTS.inwork

In pl-sql developer this variant returns information


pl-sql block result



how to show this data used JSP (JSTL)?

p.s.

before I used this variant



Please help an example of information output from the Oracle stored procedure by JSP (JSTL).
 
Dave Tolls
Ranch Hand
Posts: 2390
25
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That block doesn't return any information.
It is simply writing lines to a buffer in the db.
These can be retrieved by calls to DBMS_OUTPUT.GET_LINES (this is what SQL*Plus does, I believe).

Now, I've never tried this, but you could call that block and then, with the same Connection, try and see what happens when you call GET_LINES (it's a procedure).

Seems a rather roundabout way of doing it, though.

Is there a reason you can't call REPORTS.inwork() directly, and handle the cursor OUT parameter as a ResultSet?
 
Baranenko Nikolay
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello, Dave

some days ago I founded this resolve, used ResultSet :-)

 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!