Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: stored procedures and ASP
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
![]() |
![]() |