Strange PL / SQL Error - PLS-00103
I have had a rather strange error in SQL developer for a long time. I split my package into the simplest one and ran the variable declaration .. and even this is an error. This is what I am doing:
create or replace package body cdbmeta.pkg_metadata_check
is
procedure p_metadata_check(unit_id_start in number, unit_id_end in number)
is
begin
start_date NUMBER(10);
dbms_output.put_line('..');
end;
end;
and my error message:
PLS-00103: When familiar with one of the following characters: "= NUMBER". (@%; Symbol ": =" replaced with "NUMBER" to continue.
Completely clueless ... has anyone had this before?
+3
source to share
1 answer
You must specify variable definitions after "is" and "begin" as follows:
create or replace package body cdbmeta.pkg_metadata_check
is
procedure p_metadata_check(unit_id_start in number, unit_id_end in number)
is
start_date NUMBER(10);
begin
dbms_output.put_line('..');
end;
end;
/
The block in the procedure definition after and before the start is the same as you would use with an anonymous block like this:
declare
start_date NUMBER(10);
begin
dbms_output.put_line('..');
end;
/
+5
source to share