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