Re: Prompt in procedure

There is a get_line function in the dbms_output package, but that lacks in functionality compared with Accept.
Easiest way is to add a parameter in the procedure and pass the sqlplus num variable to that procedure

begin
proc(&num);
end;
/

This should work as a breeze.

Hth,

--
Sybrand Bakker, Oracle DBA
Stéphane D'Hoedt <sdhoedt_at_softhome.net> wrote in message news:84a588$s83$1_at_naxos.belnet.be...
> Hi,
>
> I would like to know how I can put a prompt in a procedure. I need to have
a
> variable.
> I will show you how I wanted in my procedure. I did it in sqlplu:
> The command is:
>
> SQL>ACCEPT num PROMPT 'Give a number: '
> Give a number: (Here I give a number)
>
> But I want this when I run my procedure.
> I hope there is someone that can help me.
>
> Thanks,
> Stéphane D'Hoedt
>
>
Received on Tue Dec 28 1999 - 05:42:46 CST