Re: Duh! Procedure woes testing mettle. . .

In <317B0814.41C67EA6_at_saintjoe.edu>, Brian Capouch <brianc_at_saintjoe.edu> writes:
>This ought to be simple. But I assume everyone reading this is familiar
>with Oracle's "finding information as treasure hunt" policy, so you'll
>understand:
>
>1. Somebody else bought the system; I'm stuck trying to get it going.
>2. I want to use stored procedures.
>3. All attempts to do so fail:
> SQL> create procedure foo as
> ERROR at line 1:
> ORA-00900: invalid SQL statement
>
>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 won't get money or fame for helping, but the knowledge of saving
>someone else from the brink of Oracle Insanity. . . .
>
>Thanks in advance.
>
>Brian Capouch
>Networking Specialist
>Saint Joseph's College
>brianc_at_saintjoe.edu
>
>"You guys quit having such a good time. This is school!!"

I would guess the procedural option is not installed. To install it run script Catproc.sql (this script also runs dbmsstdx.sql) connected as user Sys. Catproc.sql should be located in sub-directory \rdbms72\admin\ (the same place you found dbmsstdx.sql).

M.Landa Received on Mon Apr 22 1996 - 00:00:00 CEST