Ignore unrecognized PL/SQL

Daniele

Member³
Hi,
can someone explain to me how it works?
"When enabled, the Program Window will ignore all SQL that does not start with "create or replace ". Other SQL or SQL*Plus commands in the program file will be ignored"

But if I write code at the end of a package in the program window:

Code:
create or replace package pippo is
   --
   FUNCTION get_Revision# RETURN VARCHAR2;
   --
   FUNCTION get_RevisionTime RETURN VARCHAR2;

   -- Public function and procedure declarations
   function <FunctionName>(<Parameter> <Datatype>) return <Datatype>;

end pippo;
/
CREATE PUBLIC SYNONYM pippo FOR ute.pippo;
GRANT EXECUTE ON pippo TO R_SIU;
GRANT EXECUTE ON pippo TO R_SIU_READ;

All the code after end pippo; is recognized as error.
It was not to be ignored?
 
Last edited:
If you save this file and reopen it, the synonyms and grants will be on a separate tab page and will be ignored.
 
Back
Top