Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: stored procedures and ASP

Re: stored procedures and ASP

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Fri, 31 Mar 2000 15:13:05 +1000
Message-ID: <8c1cik$aq6$1@perki.connect.com.au>


That is correct.
You need to use package, within a package spec you will specify a ref cursore like TYPE SQL_CURSOR IS REF CURSOR; Tom

Louis Frolio <frolio_at_home.com> wrote in message news:j3AE4.31621$MZ2.431547_at_news1.wwck1.ri.home.com...
> Greetings All, I am in the process of changing from a SQL Server web
> database server
> to an Oracle 8i web database server. The web site currently uses all
stored
> procedures
> for data retrieval and I want to carry this over to Oracle also. I have
> been told that if I have
> a stored procedure that returns a record set that I cannot simply call the
> procedure. I have
> been told that I have to create a package? Can anyone confirm this? I
have
> many stored
> procedures, some perform DML's and other simply do selects. I would
> appreciate any
> help that you might be able to provide.
>
> Louis
> frolio_at_home.com
>
>
Received on Thu Mar 30 2000 - 23:13:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US