Re: Duh! Procedure woes testing mettle. . .
Date: 1996/04/23
Message-ID: <ADA2261F96685EBD_at_fjp.his.com>#1/1
In article <317B0814.41C67EA6_at_saintjoe.edu>, Brian Capouch <brianc_at_saintjoe.edu> wrote:
>4. So I find in the book I better run "dbmsstdx.sql" first. OK:
> create package dbms_standard is
> *ERROR at line 1:
> ORA-00900: invalid SQL statement
>
>Hmmm. First question: does anybody know what's going on here? Since
>the documentation says that stored procedures is an option, how can I
>find out if we have it. Or does the existence of that script imply it's
>here somewhere.
You must install the procedural option before you can create procedures. This is accomplished by running the 'catproc.sql' script, which is usually found in the /oracle/rdbms/admin directory (although you might have to search for it on your machine). Launch SQL*plus under the SYSTEM account and invoke the script:
_at_/<oracle_path_to_scripts>/catproc;
When it has finished you should be able to proceed.
+-------------+++----------------------------------------------------+| fjp_at_his.com ||| "If it sounds good, it IS good." -- Duke Ellington |
+-------------+++-------<http://www.his.com/~fjp/>-------------------+Received on Tue Apr 23 1996 - 00:00:00 CEST