Home » Developer & Programmer » Forms » TYPE OBJECTS in PLSQL
TYPE OBJECTS in PLSQL [message #246768] Thu, 21 June 2007 17:17 Go to next message
krishkrish
Messages: 6
Registered: June 2007
Junior Member
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).
Re: TYPE OBJECTS in PLSQL [message #252485 is a reply to message #246768] Thu, 19 July 2007 00:45 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Correct. Forms 6 does not support TYPE usage. It is limited to the standard character, number, and date column types.

David
Previous Topic: How To Call Form Through Another Fome(Help)
Next Topic: Editing Object In An Object Library
Goto Forum:
  


Current Time: Thu Dec 08 22:01:35 CST 2016

Total time taken to generate the page: 0.16519 seconds