Re: Duh! Procedure woes testing mettle. . .

Brian Capouch wrote:
>
> 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

Brian,

In order to install/enable the procedural option (i.e. PL/SQL, stored procedures and packages, and database triggers), it is necessary to execute the script catproc.sql. On unix systems, this script is usually found in $ORACLE_HOME/rdbms/admin along with catalog.sql, catexp.sql, ...etc. In order to execute this script, login to SQL*Plus as sys and then type _at_catproc at the SQL> prompt. CATPROC.sql automatically runs all the remaining scripts needed to install the procedural option (including, but by no means limited to dbmsstdx.sql).

Always remember, it's only a database...it can't hurt you, and Oracle looks good on your resume.

hope this helps.

regards,
Chuck

-- 
*************************************************************************
* Chuck Wolfe                       Phone: (703)838-9720
* Senior Consultant                 e-mail:  cwolfe_at_ix.netcom.com (Home)
* NDC Group, Inc                             cwolfe_at_ndcinc.com    (Work)
* 625 Slaters Lane, 
* Suite 102
* Alexandria, VA 22314
* 
* All the usual discalimers apply, except where otherwise indicated...
************************************************************************