wht is clobreplace func

thota198
thota198 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2009

Commented:
clobreplace_fn isn't any standard function I'm familiar with. Can you check the source for it, that would help explain things.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
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;

Author

Commented:
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)
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Which query?

That isn't enough to select the actual source and it isn't the output for the owner.

Author

Commented:
i ran the query
Select text from dba_source where name='CLOBREPLACE_FN' order by line;
but i couldnt understand what it meant
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
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.
Top Expert 2009
Commented:
Try this:

SELECT dbms_metadata.get_ddl('FUNCTION', 'CLOBREPLACE_FN') FROM DUAL

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial