I have an SP as
SET TERM ^^ ;
CREATE PROCEDURE P_ADD_ENTITY (
ENTITY_TYPE Char(1),
ENTITY_COMMENTS BLOB,
ENTITY_EMAIL VarChar(75),
ENTITY_RECORDSTATE Integer)
returns (
ENTITY_ID Integer)
AS..........

A "Before Insert" Trigger uses a Generator value to insert ENTITY_ID.
How do I return the ENTITY_ID once this procedure is run (the SP adds
a new record)?
This procedure is called from other SP that add Persons, Organizations
etc (all are entities). These procedures in turn are called by SP that
add Patients, Doctors, Nurses... (Persons) or Lab, Hospital,
Pharmacy.... (Organization).
Will I see any performance issues due the cascading Triggers/Stored
Procedures?
TIA