Re: PL/SQL in SQL*Plus
From: Martin Bronstein <marty_at_amelia.sp.trw.com>
Date: 1996/09/17
Message-ID: <323F28CE.7D33_at_amelia.sp.trw.com>#1/1
Date: 1996/09/17
Message-ID: <323F28CE.7D33_at_amelia.sp.trw.com>#1/1
Juan Ruiz de Miras wrote:
>
> I have problem executing PL/SQL staments into SQL*Plus. When
> I write a PL/SQL stament into SQL*Plus it appears the error: NOT A
> SQL STAMENT.
>
> What's the problem??
>
> Thanks.
You have to be in PL/SQL mode by typing BEGIN or DECLARE. Don't forget semicolons after each PL/SQL statement and END; when you are finished. Also you have to end PL/SQL mode with a . on a separate line. You can then execute with /
Hope this helps.
Marty
Received on Tue Sep 17 1996 - 00:00:00 CEST