I have function script. In it there is two function like:
CREATE OR REPLACE FUNCTION "FUNC1" (
MJOB_CODE IN VARCHAR2,
MOP_CODE IN VARCHAR2)
RETURN DATE
IS
RETDATE DATE;
BEGIN
--SOMETHING--
RETURN(RETDATE);
END;
/
CREATE OR REPLACE FUNCTION "FUNC2" (
MJOB_CODE IN VARCHAR2,
MOP_CODE IN VARCHAR2)
RETURN DATE
IS
RETDATE DATE;
BEGIN
--SOMETHING--
RETURN(RETDATE);
END;
But im getting error and when i look function in functions, I see that like function compiled like this:
CREATE OR REPLACE FUNCTION "FUNC1" (
MJOB_CODE IN VARCHAR2,
MOP_CODE IN VARCHAR2)
RETURN DATE
IS
RETDATE DATE
A part of code is missing. Actualy after ; part is missing.
If i put create function block into this missing code and compile i works. But i have too many function so i dont want to use that.
How can i solve this problem? How can i compile functions in script?
