Hi I'm newbie to pl/sql. Here is simple pl/sql procedure
I have got errors when executed foll code :
create or replace procedure scope
is
begin
v_id1 employes.employee_id%type := 100;
v_id2 employes.employee_id%type := 200;
v_name varchar2(20) := 'abc';
print (v_id1);
print (v_id2);
print (v_name);
end;
/
SQL> show error
Errors for PROCEDURE SCOPE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
6/8 PLS-00103: Encountered the symbol "EMPLOYES" when expecting one
of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "EMPLOYES" to continue.
6/34 PLS-00103: Encountered the symbol "=" when expecting one of the
following:
. ( * @ % & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
what is the cause can anyone help ?
regards