Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
This code is not parsed correctly by sql developer 4.2. It gives the message:
Syntax error. Partially recognized rules (railroad diagrams): ELSEIF plus := $ELSIF ...
on line 4 (gt_fermoccurences ...)
It seems it expects only 1 line of code after the $if
CREATE PROCEDURE TST AS
$if $$ferm_dbg $then
TYPE t_fermoccurences IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(60);
Known issue. But should be fixed for our next update.