Re: How to write a SELECT stored procedure ?

> Use cursor.
> create or replace procedure GetNames()
> begin
> open mycursor for
> select name from tbemployee;
> end ;

That will do nothing....
Plus it wouldn't compile.

I think what you want is.
To execute the stored procedure and retireve the rows on the client side.

Just use:
select name from tbemployee

there is no advantage to having it as a stored procedure that I can think of.

The probelm is proecdure won't return the results into a cursor or record set.

I think you can do it with DBMS_OUTPUT. But I've never even bothered to try.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 03 1999 - 04:23:40 CDT