Re: Duh! Procedure woes testing mettle. . .

In article <ADA2261F96685EBD_at_fjp.his.com>, fjp_at_his.com (Fred Puhan) writes:
|> 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/>-------------------+
|>
 

-- 
Scott Urman
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"