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