I have created a PL/SQL table of a type like below:
create or replace type typ_tbl_des_text is table of typ_tof_des_text
OK so far, but I'd like to have a constructor function that would perform some validations and raise_application_error when a validation condition is not met.
How to do this?
The typ_tof_des_text I have created with a constructor function, so that the record-level validations are performed in the constructor. And I think that validations between several records are to be performed in a constructor for typ_tbl_des_tex, but can't figure out how to create that type with a constructor.