Skip to Main Content
  • Questions
  • how to return result set from stored procedure.

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Prakash.

Asked: May 15, 2001 - 7:03 pm UTC

Last updated: July 26, 2018 - 2:37 am UTC

Version: 8i

Viewed 10K+ times! This question is

You Asked

We are developing an intranet application using Asp IIS and oracle 8i. I want to return a resultset from oracle stored procedure to Asp page. How do I do it?
Like in sybase you say

create procedure test (parameters) resultset (col1,col2 )

Like wise what is there in Oracle to return a resultset from a procedure to an environment outside oracle.

Thanks
Prakash


and Tom said...

Go to our Resources => Presentations, and search for "Result" to see a link on doing result sets in Oracle.

Also see Implicit Statement Results in 12c and above

https://docs.oracle.com/database/121/LNPLS/release_changes.htm#LNPLS118

Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Return resultset from procedure.

Prakash S. Ranade, May 16, 2001 - 4:13 pm UTC

The information given is very elaborate and useful. It solved my problem.

Thanks


the link is not working

reader, March 08, 2005 - 12:48 pm UTC

Thanks as always for the excellent job you are doing there.

Tom Kyte
March 08, 2005 - 3:14 pm UTC

replace OSI with ASKTOM


(i'll write an update program to do that some day....)

Broken URL.

A reader, August 04, 2005 - 9:03 pm UTC

The URL in your answer returns a 404 error.
</code> http://asktom.oracle.com/~tkyte/ResultSets/index.html <code>

Tom Kyte
August 05, 2005 - 10:16 am UTC

replace the word osi in the url with asktom


</code> http://asktom.oracle.com/~tkyte/ResultSets/index.html <code>

Broken Link

Brad, July 25, 2018 - 1:49 pm UTC

404 Returned
Connor McDonald
July 26, 2018 - 2:35 am UTC

Thanks for letting us know.

Go to our Resources => Presentations, and search for "Result"

I'll update the question

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library