Re: Problem creating procedures

From: Steven Liebler <stevel_at_logicworks.com>
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 *
Received on Wed Aug 14 1996 - 00:00:00 CEST

Original text of this message