Hi
I would like to know how do I know if a certain item already exists within type object
Example : I create a type and table of type
CREATE OR REPLACE TYPE MY_OBJTYPE AS OBJECT (ORD NUMBER,CODE_NAME VARCHAR2(6),ELEMENT VARCHAR2(60),IND_TYPE VARCHAR2(1))
CREATE OR REPLACE TYPE MY_OBJTYPE_TABLE AS TABLE OF MY_OBJTYPE;
In code below I insert 3 elements, but when insert 4th I would like to veriry if element exists
declare
Tab_clsPFJ MY_OBJTYPE_TABLE;
procedure AddCLSPFJ(pCLSPFJ MY_OBJTYPE) is
begin
Tab_clsPFJ.EXTEND;
Tab_clsPFJ(Tab_clsPFJ.LAST) := pCLSPFJ;
end;
begin
Tab_clsPFJ := NEW MY_OBJTYPE_TABLE();
AddCLSPFJ(new MY_OBJTYPE(2, 'XPTO', 'ELEMENT01', 'E'));
AddCLSPFJ(new MY_OBJTYPE(2, 'XPTO', 'ELEMENT02', 'E'));
AddCLSPFJ(new MY_OBJTYPE(2, 'XPTO', 'ELEMENT0', 'A'));
-----------------------------------------------------------------
-- HOW CAN I TO VERIFY IF EXISTS 'XPTO','ELEMENT01' AND 'E'
-----------------------------------------------------------------
AddCLSPFJ(new MY_OBJTYPE(2, 'XPTO', 'ELEMENT01', 'E'));
end;
Using
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production