Link to home
Start Free TrialLog in
Avatar of thota198
thota198

asked on

wht is clobreplace func

o_email_text := clobreplace_fn (o_email_text,
                                               v_email_replace_vals (l_cnt).fieldname,
                                               NVL (v_email_replace_vals (l_cnt).fieldvalue, ' ')
                                              );

i didnt understand the meaning of this code containing clobreplace_fn actually im using this code when replacing the placeholder fields in the proc
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

clobreplace_fn isn't any standard function I'm familiar with. Can you check the source for it, that would help explain things.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

I agree.  That is not an Oracle function.  It is a custom in-house developed function.

Check with your development staff or just extract the code:

First see how many copies exist:

Select distinct owner from dba_source where name='CLOBREPLACE_FN';

If only one then extract.  If more than one add an owner='THE_OWNER' to the select below.

Select text from dba_source where name='CLOBREPLACE_FN' order by line;
Avatar of thota198

ASKER

this is wht i got from the query given by u wht does it mean

CLOBREPLACE_FN" (i_srcclob IN CLOB, i_replacestr IN VARCHAR2, i_replacewith IN VARCHAR2)
Which query?

That isn't enough to select the actual source and it isn't the output for the owner.
i ran the query
Select text from dba_source where name='CLOBREPLACE_FN' order by line;
but i couldnt understand what it meant
Could not understand the query or the output?

The query: oracle stores all code internally.  The view to see it is called dba_source.

The output:  that is the actual code from that function.

You have asked a lot of 'understand' type questions recently.  I suggest you start in the online documentation to look up the various functions and views.  This will tell you what they do.

Then if you don't understand how they are being used, then ask us.
ASKER CERTIFIED SOLUTION
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial