DECLARE
l_configxml XMLTYPE;
l_value VARCHAR2(5) := ‘true’; — (true/false)
BEGIN
l_configxml := DBMS_XDB.cfg_get();
IF l_configxml.existsNode(‘/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access’) = 0 THEN
– Add missing element.
SELECT insertChildXML
(
l_configxml,
‘/xdbconfig/sysconfig/protocolconfig/httpconfig’,
‘allow-repository-anonymous-access’,
XMLType(‘‘ ||
l_value ||
‘‘),
‘xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”‘
)
INTO l_configxml
FROM dual;
DBMS_OUTPUT.put_line(‘Element inserted.’);
ELSE
– Update existing element.
SELECT updateXML
(
DBMS_XDB.cfg_get(),
‘/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()’,
l_value,
‘xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”‘
)
INTO l_configxml
FROM dual;
DBMS_OUTPUT.put_line(‘Element updated.’);
END IF;
DBMS_XDB.cfg_update(l_configxml);
DBMS_XDB.cfg_refresh;
END;
/
What’s up everybody, here every one is sharing these know-how, therefore
it’s fastidious to read this website, and I used
to go to see this website every day.
I blog frequently and I seriously appreciate your content.
This article haas truly peaked my interest. I
will take a nolte of your website and kee checking for new details about
once pper week. I opted inn for your RSS feed too.
Eu n‹o sou muito de ler na internet devo ser honesto, mas seu blog Ž
muito bom, continue assim! Vou continuar vendo outros sites,
mas marquei seu site nos meus favoritos. Vou voltar em breve para ver as novidades.
ParabŽns.
I’m truly enjoying the design and layout of your blog. It’s a very easy on the eyes which
makes it much more enjoyable for me to come here and visit more often.
Did you hire out a developer to create your theme?
Great work!
What’s Taking place i’m new to this, I stumbled upon this
I’ve discovered It positively helpful and it has aided me out loads.
I’m hoping to contribute & help other customers like its helped me.
Good job.
Quality articles or reviews is the main to be a focus for
the users to pay a visit the website, that’s what this website is providing.
It’s really a nice and helpful piece of information. I’m
glad that you simply shared this useful info with us. Please keep us
informed like this. Thank you for sharing.
Thanks for sharing such a pleasant idea, paragraph is good, thats why i have read it entirely
This page really has all the information and facts I wanted concerning
this subject and didn’t know who to ask.
Hi there mates, how is the whole thing, and what you want to say about
this paragraph, in my view its in fact remarkable for me.
Feel about all key phrases linked to your weblog.
It’s a shame you don’t have a donate button! I’d moset certainly donate to
this brilliant blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to my
Google account. I look forward to new updates and will talk about this website with my Facebook group.Chat soon!
https://professionalessaywritingservice.com
best websites to write essays
best websites to write essays
https://professionalessaywritingservice.com
I feel that is one of the such a lot significant information for me.
And i’m happy studying your article. However should observation on some
normal things, The web site style is perfect, the articles is
in point of fact great : D. Excellent task, cheers
Its such as you read my thoughts! You seem to know
so much approximately this, like you wrote the e-book
in it or something. I feel that you simply could do with some p.c.
to pressure the message home a little bit, but other than that, this is fantastic
blog. A great read. I’ll definitely be back.