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:
All the code after end pippo; is recognized as error.
It was not to be ignored?
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: