Re: Requirements to create stored procedures

Stefano UNTERNAEHRER (unter_at_mecati.mecasoft.ch) wrote:
: 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;

put a / on the last line after the end;

Hope it helps,

--
Stephane Lentz			lentz_at_emi.u-bordeaux.fr
-------	* DESS GENIE LOGICIEL (SOFTWARE ENGINEERING) * --------
---It's better to burn out then to fade away ------------------