See the Oracle PL/SQL documentation for information about "cursor
variables". Depending on the client environment, you may or may not be able
to use this, but this does provide a way to access data from a select
statement that was declared in a stored proc.
<sheldon5954_at_my-deja.com> wrote in message
news:85m56v$38l$1_at_nnrp1.deja.com...
> When I was using MS SQL SERVER , I always put
> select clause in a store procedure to return
> the result set, people can only call the store
> procedure to get the qurey result.
> Now I change to Oracle, but I when I write such a
> clause in PL/SQL procedure
> select * from tab1;
> It can not be compiled. it can not work like this.
>
> please tell me how can I do this. How do u do
> these things . thx!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 17 2000 - 16:38:59 CST
