Re: Newbie Question: Simple Stored Procedure

>LOUIS WROTE:

>Greeting All, I have a table schema.table which has
>many rows of data. I want to write a simple stored
>procedure that will pull all the rows from this table;
>
>create or replace procedure schema.procedure
>as
>begin
> select * from schema.table
>end;
>/
>
>When I run the above script I get all kinds of compilation
>errrors?? Can anyone help me with the above procedure?
>
>Much Thanks, Louis
>frolio_at_videoshare.com
>
>
>Hi,

Is schema.procedure, schema.table what you are actually naming these?? If so, I believe they are all reserved words which will cause a whole lot of problems. Give them some meaningful names.
S
>
>
>
>
>

>
>G
Received on Thu Mar 30 2000 - 13:11:22 CST