Hi,

Does anyone know how to execute an update queary within the stored procedure.

I would like to execute the following update query in the stored procedure and then use the trigger AFTER insert or update to execute the stored procedure.

----------------------------------------
Select UPPER(company_name)
From company_leads;

Update company_leads
set company_name = Upper(company_name);
----------------------------------------

Thanks for your help.

Roman