Re: Problem creating procedures
Date: 1996/08/14
Message-ID: <32124fd2.1138537_at_news.nosc.mil>#1/1
On 14 Aug 1996 19:43:29 GMT, mohammed_at_altrax.ils.nwu.edu () wrote:
>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
I believe you have to "install" the procedural option on your Oracle instance....There should be a file in RDBMS7X (X=your version of Oracle)/admin called catproc.sql. Running it when connected as SYS will install the stuff so you can create procedures.
Steve Liebler [http://www.logicworks.com] Senior Product Consultant stevel_at_logicworks.com Logic Works, Inc. Phone: 609.514.2037
- Introducing ModelMart. *
- Now you can share ERwin models *
- without losing control *