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
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
clobreplace_fn isn't any standard function I'm familiar with. Can you check the source for it, that would help explain things.
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;
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;
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)
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.
That isn't enough to select the actual source and it isn't the output for the owner.
ASKER
i ran the query
Select text from dba_source where name='CLOBREPLACE_FN' order by line;
but i couldnt understand what it meant
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.