a newwbie's question

From: rsenn <rsenn_at_capaccess.org>
Date: 1997/10/16
Message-ID: <344668D8.B7A3A8AA@capaccess.org>#1/1

I'm having trouble with building a simple PL/SQL procedure. Can somebody tell me what I'm missing, please?

Create or replace Procedure add_emp
is
Begin

Accept v_name prompt 'Enter the employee s name: ' ;
Accept v_id prompt 'Enter the employee s id: ' ;
Accept v_date prompt 'Enter the effective date using MM/DD/YYYY format:

' ;
Insert into emp_hist
  ( name, id, effective_date )
  values ( '&&v_name', &&v_id,

           to_date('&&v_date', 'MM/DD/YYYY' )   ) ;
commit;
END add_emp;

  The body of this, the Accept statements and insert statement, work just fine when
run as a script file (Add_Emp.SQL). I'm clearly missing something, but be danged if I see it.

  Thanks for your help. Received on Thu Oct 16 1997 - 00:00:00 CDT