Re: HELP me

From: Frederick C. Lee <fclee_at_earthlink.net>
Date: Sat, 16 Dec 2000 03:54:16 GMT
Message-ID: <B660279D.1FA3%fclee@earthlink.net>

in article ebo_5.108576$hk4.3928283_at_news.infostrada.it, MP at mauro-papagno_at_libero.it wrote on 12/15/00 5:32 AM:

> I'm crazy with this Store Procedure
> when edit the statement RUN in SQL*PLUS he tell me:
> :
>
> - Procedure created with compilation errors.
>
> What I wrong ?
> I try the change AS with IS , but nothing.
>
> HELP HELP
>
> Thanks and Good Work.
> Ciao e Buon Lavoro.
>
> Store Procedure:
> CREATE OR REPLACE PROCEDURE sp_prova2 (PP IN Varchar2)
> IS
> BEGIN
> SELECT * FROM NEW_BC_SERVICES_FACT WHERE BC_SERVICE_NAME = PP;
> END sp_prova2;
> /
>
>
>
>
>

Use 'show error' at the SQL> prompt to see what the reason is.

Ric. Received on Fri Dec 15 2000 - 21:54:16 CST