Re: a newwbie's question

From: wds <clyde.tarver_at_turner.com>
Date: 1997/10/17
Message-ID: <01bcdaf7$4f53cac0$b427a69d@pc86208.turner.com>#1/1

Accept is a SQLPlus command and only works within SQLPlus.

You can call a stored procedure and pass the accept values to it

Create your SP:

Create or Replace Procedure add_emp
( p_name emp_hist.name%type,

    p_id emp_hist.id%type,
    p_effective_date emp_hist.effective_date%type   ) as

Begin
  Insert into emp_hist
(

     name, 
     id, 
     effective_date

  )
  values
 (

   p_name, 
   p_id,
   p_effective_date

 ) ;
commit;

End;
/

Create a SQLPLus Script:

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:

Execute add_emp('&&v_name', '&&v_id', to_date('&&v_date', 'MM/DD/YYYY' ); Received on Fri Oct 17 1997 - 00:00:00 CDT