Sitemap

Amicuk Programming Answers

10.2: loading DBMS_XMLDOM package

-0001-11-30   Views:2

Advertisement

I'm getting errors of the form identifier 'DBMS_XMLDOM.DOMNAMEDNODEMAP' must be declared when I run my stored procedure. What script needs to be run in Oracle 10g to create this package?I ran that, and that gives this error - do we need to create an

I'm getting errors of the form identifier 'DBMS_XMLDOM.DOMNAMEDNODEMAP' must be declared when I run my stored procedure.
What script needs to be run in Oracle 10g to create this package?

The replay answer
Advertisement
I ran that, and that gives this error - do we need to create an xdb user? Is there a stock script for creating this user?
SQL> start dbmsxmld.sql;
CREATE OR REPLACE PACKAGE xdb.dbms_xmldom AUTHID CURRENT_USER IS
ERROR at line 1:
ORA-01435: user does not exist
No errors.
Synonym created.
Synonym created.
Synonym created.
GRANT EXECUTE ON xdb.dbms_xmldom TO PUBLIC
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
GRANT EXECUTE ON sys.xmldom TO PUBLIC
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.XMLDOM
ORA-00980: synonym translation is no longer valid
ORA-00980: synonym translation is no longer valid
No errors.
SQL>

Go to See the other 6 answers

10.2: loading DBMS_XMLDOM package

Category:DefaultRelease time:-0001-11-30Views:130

I'm getting errors of the form identifier 'DBMS_XMLDOM.DOMNAMEDNODEMAP' must be declared when I run my stored procedure. What script needs to be run in Oracle 10g to create this package?I ran that, and that gives this error - do we need to create an[More]

Error in BPC Load infoprovider Package

Category:DefaultRelease time:2015-10-11Views:130

Hi, We upgraded BPC netweaver 7 to version 7.5.When we are trying to load the data from BI cube to BPC cube by using Load Infoprovider Package we got error.Please find the Error details below /CPMB/MODIFY completed in 0 seconds /CPMB/INFOPROVIDER_CON[More]

Error when using DBMS_XMLDOM package

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have created a set of triggers that use the DBMS_XMLDOM packages. These triggers were created on a Win 2k install of 9.2.0.2.1. A brand new user was created and a specific set of permissions granted. The permissions were: GRANT CONNECT, RESO[More]

How to install SWC and load the package in CS3

Category:DefaultRelease time:2015-10-11Views:130

hello, does anyone know how to install a swc and load the package? I have installed the two SWC as3corelib-.92.1 and xmlsyndication.swc into components, but when I call the package from an AS file nothing happens other than, 1172: Definition com.adob[More]

Error in BPC Load infoprovider Package after upgraded BPC NW 7 to 7.5

Category:DefaultRelease time:2015-10-11Views:130

Hi, We upgraded BPC netweaver 7 to version 7.5.When we are trying to load the data from BI cube to BPC cube by using Load Infoprovider Package we got error.Please find the Error details below /CPMB/MODIFY completed in 0 seconds /CPMB/INFOPROVIDER_CON[More]

Unable to load the package as XML because of package does not have a valid XML format

Category:DefaultRelease time:2015-10-11Views:130

I have SSIS package and I would like to let SQL Server Agent Job to run it. However I get Unable to load the package as XML because of package does not have a valid XML format What could be wrong? Kenny_IHi Kenny, What's the version of your SSIS? Ple[More]

What Channel (Other Then Movie Channels) Come with The Fully Loaded Entertainment Package?

Category:DefaultRelease time:-0001-11-30Views:130

I currently have Verizon FiOS Prime TV (now known as preferred) along with 75/75 internet with the fully loaded entertainment package. I receive many channels in my package that are not listed under the Prime package. These include NFL Network, GSN,[More]

Differences between XMLDOM and DBMS_XMLDOM packages

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, Anybody could tell me if exists any differences between XMLDOM and DBMS_XMLDOM packages. Which are these? I have Oracle9i Enterprise Edition Release 9.2.0.3.0 Thanks.hi, Can you check this Document TitleORA-1031 when setting Attribute via DBM[More]

Loading Seperate Packages to same target

Category:DefaultRelease time:-0001-11-30Views:130

Can I load parallel packages with different selection criteria to the same target at the same time, if so is there any possible impact that I should be aware of? ThanksHi, Yes you can do that. But I would suggest you do that in a staggered manner, i.[More]

Error in loading WebUtil package

Category:DefaultRelease time:2015-10-11Views:130

Dear all, i have the following problem, we have install the application server on one machine Windows server 2003 Enterprise edition (both the infra and middle tier on the same machine), and we wanted to configure the webutil package with this instal[More]

Failed to load Execute Package Task error.

Category:DefaultRelease time:2015-10-11Views:130

Hello Experts, Excuse my newbie question. Execute Package Task: Error: The task has failed to load. The contact information for the task is "Microsoft Corporation; Microsoft SQL Server; Microsoft corporation; All Rights Reserved http://www.microsoft.[More]

Hot
When I turn my computer on, my keyboard does not respond.  I have to re-start the system in order to get it to respond (every time).  I have changed the batteries, for the mouse and keyboard.  I have moved the keyboard closer to the system, and that [More]
I have a serious problem, i want to copy photos dragging them from my pc pictures folder to my iphone in my explorer and i can't do it anymore!!! i could do it two days ago and now i can't please help me! i restarted the iphone i the problem is still [More]
Here is the scenario: 1. Created logical star schema model including a dimension with nested subtypes (SuperTypeEntity1 -> Subtype 1 -> Nested Subtype 2) 2. Forward engineer to Relational model using Single Table implementation 3. Create Oracle 11g [More]
Well the title says it all. I installed Safari 5 today and since then i cannot upload ANYTHING to the web. Thanx Apple, great upgrade.According to your profile you do not have the right version of Mac OS X to install Safari 5. AllanRead other 4 answe [More]
My iPad 2 was working then went dead and now won't charge or even turn on. I have tried different chargers to make sure it wasn't the charger it self. I have been told it might be the port or the battery it self. Or even maybe something called a ghos [More]
I heard there is a way to run snow leopard alongside lion so i can run my powerpc applicationsThe makers of virtualization software do not support Snow Leopard, only Snow Leopard Server.  But it is possible to bypass this and force an installation of [More]
We use Weblogic 7.0 running behind IIS as a web server. The IIS server takes care of the SSL traffic/certificate. We like our web services to use SSL. Is there a way to do this without WL doing the SSL traffic? If we specify 'protocol="https"' i [More]
When I start Firefox it loads only the last tabs I had when closing. BUT if I then hit the home icon it fills the tab bar with pages I was on weeks and weeks before, I dont seem to find a way to stop it.'''bold text'''Did you check the Home page sett [More]
I am from South Africa. I bought a bb 8520 curve December it worked fine until a month ago. When I sends bum it is slow and shows me a watch and then on my home screen it says searching for signal for a long time than shows sos. Then I get signal and [More]
     I've been having my apple id since the year 2011 and not once did I ever try to purchase anything until last year. So I brought my first ever iTunes gift card of $15 and redeemed it in my account. When I tried to buy something, it asked for secu [More]