Re: PL/SQL in SQL*Plus
From: <mlanda_at_vnet.ibm.com>
Date: 1996/09/10
Message-ID: <513vjn$1ce5_at_watnews1.watson.ibm.com>#1/1
Date: 1996/09/10
Message-ID: <513vjn$1ce5_at_watnews1.watson.ibm.com>#1/1
In <3235601E.3F55_at_apolo.ujaen.es>, Juan Ruiz de Miras <demiras_at_apolo.ujaen.es> writes:
>I have installed a ORACLE v7 DataBase Server. The only modules that
>I have installed are SQL*Plus and SQL*Forms 3.0. The installation was
>successfuly, but, when I wrote a PL/SQL stament in the SQL*Plus prompt,
>appears the error: NOT A SQL stament...
>
> What is the problem??
>
> Thanks.
You will have to install the procedural option to use PL/SQL. In sqlplus or sqldba connected as user SYS run the script "catproc.sql" located in the /rdbms/admin subdirectory.
M.Landa Received on Tue Sep 10 1996 - 00:00:00 CEST