Hello,

I will migrate a little system from oracle to firebird (100 tables).
This system use a lot of editable views, and user defined types for
passing parameters thru view's triggers and final procedures, like the
simplified model:

My question is: I have to create as many parameters as my "TYPE
BUSINESS_OBJET" for my stored procedures, or there is a shortcut?

VIEW:
FIELD_A, FIELD_B, FIELD_C

TYPE BUSINESS_OBJECT:
FIELD_A%type, FIELD_B%type, FIELD_C%type

trigger:
do validations and
call a stored procedure passing just ONE parameter of TYPE BUSINESS_OBJECT

procedure:
insert or update, audit, do a lot of other stuff

TIA.
--
Valdir.