Requirements to create stored procedures

From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/08/29
Message-ID: <DE2oxI.qL_at_mecati.mecasoft.ch>#1/1

Hi folks!
I'm trying to create my first stored procedure, but it seems I've missed some step. Here is what I've done:

1- as a certain user (table owner) I start an sqlplus session

   giving this command:

SQL> create procedure
  2 mecaora.elem_mod_chiave(old_val in integer, new_val in integer)   3 as
  4 v_sigla varchar2(6);
  5 begin

  6     select ...;
  7     insert ...;
  8     update ...;
  9     delete ...;

 10 end;
 11

Here I've noted the first problem... how to STOP the 'create procedure' ?? Why is the '11' arrived ?? So, maybe I don't have run the dbmsstdx.sql script as sys user;

2- as sys user I start an sqlplus session giving the command:

SQL> AT/users/oracle7/rdbms/admin/dbmsstdx.sql

     (sorry for the AT, I can give the 'at' sign in this shell..)

Here is the output:
**************************** BEGIN OUPUT ******************************
drop package dbms_standard
*

ERROR at line 1:
ORA-04043: object DBMS_STANDARD does not exist

create package dbms_standard is
*

ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible

create package body dbms_standard is
*

ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible

Synonym dropped.

Synonym created.

grant execute on dbms_standard to public

                 *

ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist

• END OUPUT ******************************

Why is this script failing? What have I missed? What I have to do? Thank you for any info!!!

Stefano

---

______________________|    Stefano Unternaehrer    |__________________________
\  Mecasoft SA        |         Oracle DBA         | fax:    +41 93 335 507  /
 \ 6600 Muralto       |     and  PL/SQL, Pro*C     | voice:  +41 93 337 444 /
  \                   |     C, XWindow & Motif     |                       /
  /                   |     Software Developer     | email:                \
 / Switzerland Europe |____________________________|  dba,unter_at_mecasoft.ch \
/________________________)                      (____________________________\

Received on Tue Aug 29 1995 - 00:00:00 CEST