Greetings!
Can anyone suggest a query that will tell me the names of all functions (both trigger and normal) that contain a given string of text?
Here's what happened:
My company's database has a table named "charge" and a view named "availcharges" that returns all charges that are available. The view's SELECT statement lists all fields in the charge table explictly.
We have two functions that use data in the charge table the same way:
declare
ChargeRec charge%rowtype
begin
select into ChargeRec * from availcharges
This used to work. But then one of us added a field to the charge table, as the last field in the table. The availcharges view was adjusted accordingly. However, behind the scenes something changed. I'm pretty sure that the view no longer returns fields in the same order. My immediate fix was to suggest using either
declare
ChargeRec record;
or
declare
ChargeRec availcharges%rowtype;
Either one works.
But I need to make sure that we don't get burned by this anywhere else. Therefore, I would like to be able to find all functions that uses the phrase "charge%rowtype". I haven't been able to find where the text of functions is stored.
Thank you very much.
RobR