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: '
name VARCHAR2(100) := &n;
BEGIN DBMS_OUTPUT.PUT_LINE('Welcome ' || name);
all i want to do is to be able to input a string from the promt and assign that string to a variable.
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
Joined: Jan 24, 2006
The accepted value &n is the string you entered at the prompt, so must be enclosed with ' ' . name VARCHAR2(100) := '&n' ; should work