Re: Problem creating procedures

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 *

  ---