Unable to get user input in PL in sqldeveloper

Question

I'm trying to get user input in SQLDeveloper in a procedure. But however , I'm getting some error like "missing defines". Please help me to solve this. Thanks in advance.

DECLARE
a NUMBER(5);    
BEGIN
a := :a;
DBMS_OUTPUT.PUT_LINE('We took the number as ' || a);
END;

The error looks like this.

Error starting at line : 1 in command -
DECLARE
a NUMBER(5);    
BEGIN
a := :a;
DBMS_OUTPUT.PUT_LINE('We took the number as ' || a);
END;
Error report -
Missing defines
We took the number as 15

Although I'm getting the correct answer at bottom, still why this errors?

I am not facing any error in sqldeveloper – Shravan Yadav Jun 06 '16 at 07:29 — Shravan Yadav, Jun 06 '16 at 07:29

score 0 · Answer 1 · answered Jun 06 '16 at 06:12

0

Please execute the below statement:

  DECLARE
    a NUMBER(5):=15;    
    BEGIN
    a := a;
    DBMS_OUTPUT.PUT_LINE('We took the number as ' || a);
    END;

answered Jun 06 '16 at 06:12

Piyush

19
4

Thanks for the reply but I want user input. – lu5er Jun 07 '16 at 07:15

score 0 · Answer 2 · answered Jun 08 '16 at 05:34

0

In order to get user input in PLSQL Block, we use &, &givenumber will get the user input at run time.

DECLARE
a NUMBER(5);    
BEGIN
a := &givenumber;
DBMS_OUTPUT.PUT_LINE('We took the number as ' || a);
END;

answered Jun 08 '16 at 05:34

Piyush

19
4

Unable to get user input in PL in sqldeveloper

2 Answers2