Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PL/SQL substitution variable

 
Sen Aff
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,

i am new to oracle 9i PL/SQL and i am having trouble running the following
program;


SET SERVEROUTPUT ON
set verify off

ACCEPT n PROMPT 'Please enter your name: '

DECLARE

name VARCHAR2(100) := &n;

BEGIN
DBMS_OUTPUT.PUT_LINE('Welcome ' || name);

END;
/


all i want to do is to be able to input a string from the promt
and assign that string to a variable.

thank you.


Sen Aff.


this is the error:
*
ERROR at line 4:
ORA-06550: line 4, column 30:
PLS-00201: identifier 'E' must be declared
ORA-06550: line 4, column 13:
PL/SQL: Item ignored
ORA-06550: line 9, column 50:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 9, column 15:
PL/SQL: Statement ignored
 
Agador Paloi
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The accepted value &n is the string you entered at the prompt, so must be enclosed with ' ' . name VARCHAR2(100) := '&n' ; should work
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic