Re: Stored Procedure Syntax

Scott Metro wrote:
>
> Hi,
> I am transitioning from Sybase to Oracle and haven't received my help
> manual yet. The syntax for creating stored procedures seems to be quite
> different from Sybase. Can someone please tell me what the syntax would be
> to create a stored procedure that simply executes the following SQL:
>
> SELECT * FROM EMPLOYEE;
>
> In Sybase it would simply be:
>
> create PROCEDURE USP_TEST ( )
> AS SELECT * FROM EMPLOYEE;
>
> Any help is greatly appreciated!
>
> Scott
> smetro_at_world.std.com

In ORACLE, stored procedures CAN NOT have a SELECT statement that returns data to the front end. The only SELECT statement allowed is a SELECT...INTO. BTW, #temp table are not supported in ORACLE either.

-- 
____________________________________
Oleg Dimerman (olegd_at_e-mail.com)