Re: Problem creating procedures

From: Bob Leonard <farsider_at_postoffice.ptd.net>
Date: 1996/08/22
Message-ID: <321bbc68.0_at_downed.ptd.net>#1/1


There is a script that needs to be run to enable user procedures to be compiled and tracked. I believe the script is called catproc.sql in your $oracle_home/rdbms/admin directory (UNIX - Oracle 7.2 ) this needs to be run as sys or in sqldba connect internal.

I hope this helps.
Bob

In article <4uta91$csh_at_news.acns.nwu.edu>, mohammed_at_altrax.ils.nwu.edu says...
>
>Hi,
>
>I'm getting a syntax error (ORA-00900: invalid SQL statement) when I
>execute:
>
>create procedure getmop as
>begin
>null;
>end;
>
>SQLDBA barfs on anything after the procedure name. I've tried many
>variations of procedures with argument list, is instead of as etc.
>Nothing seems to work.
>
>Also what does it mean to "use ORACLE with the procedural option"?
>I'm thinking that this is the source of my problems.
>
>Thanks
>Riad
Received on Thu Aug 22 1996 - 00:00:00 CEST

Original text of this message