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?
CREATE OR REPLACE PROCEDURE p_tyims_tester (
al_applicationid IN NUMBER
-- Type declaration.