OraFAQ Forum: Forms » LOV form errors when using objects

Home » Developer & Programmer » Forms » LOV form errors when using objects

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LOV form errors when using objects [message #219282]

Tue, 13 February 2007 16:13

sophia_786
Messages: 13
Registered: February 2007
Location: manchester

Junior Member

Hi,

I am currently designing an object-relational databas on oracle 9i.

I am getting errors, early on in this project i was wondering if anyone can help.

I am creating a form using 6i, i want to link an LOV to a field.

the following code created the types and objects.

CREATE TYPE EmpStatus_objtyp AS OBJECT (
EMP_STATUS VARCHAR2(100)
);
/
CREATE OR REPLACE TYPE Employee_objtyp AS OBJECT (
EMP_ID VARCHAR2(9),
EMP_FNAME VARCHAR2(50),
EMP_SNAME VARCHAR2(50),
STATUS_REF REF EmpStatus_objtyp
);
/

CREATE TABLE EmpStatus_objtab OF EmpStatus_objtyp (
PRIMARY KEY (EMP_STATUS))
OBJECT IDENTIFIER IS PRIMARY KEY;

CREATE TABLE Employee_objtab OF Employee_objtyp (
PRIMARY KEY (EMP_ID),
FOREIGN KEY (STATUS_REF) REFERENCES EmpStatus_objtab)
OBJECT IDENTIFIER IS PRIMARY KEY;

INSERT INTO EmpStatus_objtab VALUES ('Permanent');
INSERT INTO EmpStatus_objtab VALUES ('Temporary');
INSERT INTO EmpStatus_objtab VALUES ('Contractor');

I am wanting the STATUS_REF field in the form to bring up an LOV to select a possible status.

thank u in advance

[Updated on: Tue, 13 February 2007 16:17]

Report message to a moderator