Re: PL/SQL error running catproc.sql

A copy of this was sent to "Müller René" <rene.mueller_at_datura.ch> (if that email address didn't require changing) On Thu, 18 Nov 1999 15:18:26 +0100, you wrote:

>Oracle8 Personal Edition:
>If we load and run the sql-script catproc.sql wich should create various
>procedures into the database, we get a syntax error like: missing quotes for
>a character string.
>Without any linenumber.
>We run the script in the SQL*PLUS-Window.
>
>
>mail-address:
>rene.mueller_at_datura.ch
>

all scripts in the oracle_home/rdbms/admin directory (cat*, dbms*, utl*, prvt*) must be run using svrmgrl (server manager) when connected as sys or INTERNAL only.

sqlplus will not properly run those scripts.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Nov 18 1999 - 11:58:40 CST