PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.
582939Jun 13 2007 — edited Jun 14 2007Hi all. I'm new to Oracle (been working with MS SQL for too long) and was trying to put together a procedure. However, I keep getting the error:
Error(15,1): PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.
I tried searching the forums, googling, yahooing, etc. to no avail so I thought I'd give you all a shout to see if anyone can help me.
I'm using SQL Developer 1.2.0 which connects to a 9.2.0.6.0 DB. My SQL+ is version 8.1.7.0.0. Again, I don't know if the difference in DB & SQL+ versions have anything to do with the problem, but I just thought I'd throw it out there. Here's the code:
create or replace
procedure upd_rev_ex_xref
(dept_id in varchar2,fund_cd1 in varchar2,yr in varchar2) is
rev_seq VARCHAR2(8);
ex_seq VARCHAR2(8);
begin
select max(seq_nbr)+1 into rev_seq from ps_kk_rev_xref;
select max(seq_nbr)+1 into ex_seq from ps_kk_ex_xref;
if rev_seq=ex_seq then
INSERT INTO PS_KK_REV_XREF VALUES(rev_seq,dept_id,fund_cd1,yr,);
INSERT INTO PS_KK_EX_XREF VALUES(rev_seq,dept_id,fund_cd1,yr);
else
dbms_output.put_line('Error!! Table Sequence Numbers DO NOT Match.');
end if;
end;
/
The code is suppose to grab the user's input, calculate what the next sequence number is, validate that the next sequence number in both tables are the same, and then insert the data into the tables. (Note: In the code above, I'm only showing the fields that will be affected by the variables. These tables are not exact replicas of one another.)
Any help would be great.
Thanks,
Joe