Re: s-procedure-help

From: JEFF CHAMBLEE <chamblej_at_author.gsfc.nasa.gov>
Date: 11 Jul 1994 07:52 -0500
Message-ID: <11JUL199407524889_at_author.gsfc.nasa.gov>


In article <1994Jul7.153709.193_at_msus1.msus.edu>, joya_at_mhd1.moorhead.msus.edu (Joya M. Sharif) writes...
>Hi Everybody:
>
>I am not sure how and where I can start. I wanted to write stored
>procedure for front-end powerbuilder. Sometime it says, not sufficient
>priviledges. Then I started sqldba command, and type this. Will
>appeciate any help.
>
>>create or replace procedure dummy
>as begin
> select * from asp_customer;
>end;
>/
>
>
>ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
>
>Thanks
>joya
>
>joya_at_mhd1.moorhead.msus.edu
>
>

See page 7-2 of Oracle7 Server Applications Developer's Guide wherein it tells you to run CATPROC.SQL. Received on Mon Jul 11 1994 - 14:52:11 CEST

Original text of this message