I'm using Oracle Forms version 6.0.8.11, PLSQL version 8.0.6.0
I am trying to create an object in my PLSQL and am getting a compilation error. But when I use the following command using TOAD I am able to create the TYPE OBJECT.
CREATE OR REPLACE TYPE FIELD_VALUE AS OBJECT
(
STRING_VALUE NCLOB,
NUMBER_VALUE NUMBER,
DATE_VALUE DATE,
CONSTRUCTOR FUNCTION FIELD_VALUE(STRING_VALUE IN NCLOB) RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION FIELD_VALUE(NUMBER_VALUE IN NUMBER) RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION FIELD_VALUE(DATE_VALUE IN DATE) RETURN SELF AS RESULT
);
The following code I used in my PLSQL to create the TYPE OBJECT and I get compilation errors.
TYPE FIELD_VALUE IS OBJECT(STRING_VALUE NCLOB,
NUMBER_VALUE NUMBER,
DATE_VALUE DATE,
CONSTRUCTOR FUNCTION FIELD_VALUE(STRING_VALUE IN NCLOB) RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION FIELD_VALUE(NUMBER_VALUE IN NUMBER) RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION FIELD_VALUE(DATE_VALUE IN DATE) RETURN SELF AS RESULT);
Can somebody help me in telling me what I am doing wrong. The reason I am not creating directly in APPS schema is that my forms version is not letting me use schema based OBJECT types in my PLSQL(some RPC error).