Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: A stupid little problem.

Re: A stupid little problem.

From: Gary O'Keefe <gary_at_onegoodidea.com>
Date: Fri, 23 Jul 1999 08:42:43 GMT
Message-ID: <37982a19.401962@news.hydro.co.uk>


On Thu, 22 Jul 1999 09:52:54 -0600, Chris <coopercj_at_cadvision.com> wrote:

> I am a beginner. I am trying to get the accept command to work. When
>ever I put the accept command into the script it causes errors. I just
>want the script to stop and accept user input, and then continue.
>
>SET ECHO OFF
>SET VERIFY OFF
>VARIABLE g_result NUMBER
>ACCEPT p_num1 PROMPT 'Please enter the first number: '
>ACCEPT p_num2 PROMPT 'Please enter the second number: '
>DECLARE
> v_num1 NUMBER(9,2) := &p_num1;
> v_num2 NUMBER(9,2) := &p_num2;
>BEGIN
> :g_result := (v_num1/v_num2) + v_num2;
>END;
>/
>PRINT g_result
>SET VERIFY ON
>SET ECHO ON
>
>does not work.

It does on my system. I copied the code above verbatim and it worked fine. What error messages are being generated?

Gary
--
Gary O'Keefe
gary_at_onegoodidea.com

You know the score - my current employer has nothing to do with what I post Received on Fri Jul 23 1999 - 03:42:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US