Hi all,
Looking for some advice or reading material on TYPES in Oracle. I have jsut started using them in PL/SQL packages as a means of passing large amounts of data to and from a bunch of functions and procedures.

My question - Is there a easy way of initializing an object of a given type? An example might help to explain my situation. Currently I can only get it to work be setting each property or nested TYPE to NULL. Can I use the NEW keyword to help initialise the object?

Regards
Darcy

CREATE OR REPLACE PROCEDURE p_tyims_tester (
al_applicationid IN NUMBER
)
IS
-- Type declaration.
l_tyimsrecord tyims_record;

BEGIN
-- Initialise TYIMS Object.
l_tyimsrecord :=
tyims_record (NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
);

-- Populating object.
SELECT tid.applicationid,
tid.draftcommentstxt,
tid.nationalkey,
tid.apprenticeship,
tid.apprentice,
tid.guardian,
tid.employer,
tid.employment,
tid.rto,
tid.nac,
tid.miscellaneous,
tid.trainingplan
INTO l_tyimsrecord.applicationid,
l_tyimsrecord.draftcommentstxt,
l_tyimsrecord.nationalkey,
l_tyimsrecord.apprenticeship,
l_tyimsrecord.apprentice,
l_tyimsrecord.guardian,
l_tyimsrecord.employer,
l_tyimsrecord.employment,
l_tyimsrecord.rto,
l_tyimsrecord.nac,
l_tyimsrecord.miscellaneous,
l_tyimsrecord.trainingplan
FROM tyims_import_data tid
WHERE tid.applicationid = al_applicationid;

etc......