how to take a number from user in a variable in oracle10g pl/sql

Question

0.00/5 (No votes)

See more:

please help i want to take input from user in oracle10g pl/sql
how can i take
i got this code from a website but it is not working

MIDL

declare
x number;
begin
x := &enter_value;
dbms_output.put_line(x*2);
end;

Posted 13-Jun-11 20:46pm

adilmemon

Updated 13-Oct-19 23:02pm

Add a Solution

Comments

Hemant_R_D 9-Mar-12 0:58am

There is no direct way to input from user in oracle 10g.All other PL/SQL I/O is done through APIs that interact with other programs. For example, the DBMS_OUTPUT package has procedures such as PUT_LINE. To see the result outside of PL/SQL requires another program, such as SQL*Plus, to read and display the data passed to DBMS_OUTPUT.

=>HTF and HTP for displaying output on a web page
=>DBMS_PIPE for passing information back and forth between PL/SQL and
operating-system commands
=>UTL_FILE for reading and writing operating-system files
=>UTL_HTTP for communicating with web servers
=>UTL_SMTP for communicating with mail servers

Although some of these APIs can accept input as well as output, there is no built-in language facility for accepting data directly from the keyboard. For that, you can use the PROMPT and
ACCEPT commands in SQL*Plus.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hemant_R_D · Answer 1 · 2012-03-08T18:58:00

There is no direct way to input from user in oracle 10g.All other PL/SQL I/O is done through APIs that interact with other programs. For example, the DBMS_OUTPUT package has procedures such as PUT_LINE. To see the result outside of PL/SQL requires another program, such as SQL*Plus, to read and display the data passed to DBMS_OUTPUT.

=>HTF and HTP for displaying output on a web page
=>DBMS_PIPE for passing information back and forth between PL/SQL and
operating-system commands
=>UTL_FILE for reading and writing operating-system files
=>UTL_HTTP for communicating with web servers
=>UTL_SMTP for communicating with mail servers

Although some of these APIs can accept input as well as output, there is no built-in language facility for accepting data directly from the keyboard. For that, you can use the PROMPT and
ACCEPT commands in SQL*Plus.

Hemant-S.S.Aggrawal

malasani · Answer 2 · 2011-06-13T21:38:00

Solution 1

code is right,but make sure in DBMS OUTPUT tab turn output on.
Please let me know if you any problem.

Thanks & regards,
Rajasekhar Reddy Malasani

Posted 13-Jun-11 21:38pm

malasani

Comments

adilmemon 14-Jun-11 11:57am

thanx sir
but ya it is on
i am using oracle 10g
n when i am not taking input inittialize then display it is working

and i am getting this eror when i run this

ORA-06550: line 4, column 6:
PLS-00103: Encountered the symbol "&" when expecting one of the following:

( - + case mod new not null
avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date

pipe

2. x number;
3. begin
4. x := &enter_value;
5. dbms_output.put_line(x*2);
6. end;

adilmemon 14-Jun-11 13:50pm

please someone give me answer first i need it very urgently

Tanvir Patel · Answer 3 · 2015-09-25T18:42:00

Solution 3

declare

a number(6);

begin

a:= :x;

dbms_output.put_line('Inputed Number is >> '|| a);
end;

/

Posted 25-Sep-15 18:42pm

Tanvir Patel

Member 14621976 · Answer 4 · 2019-10-13T23:03:00

Solution 6

use variable_name:=:variable_name;

Posted 13-Oct-19 23:03pm

Member 14621976