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
IN VF02 smartforms ENTRY form , I add a function about save PDF at local PC. When I print the smartfomrs,There is ERROR message in update modules. IN SM13 can see the ERROR message. Function Module: RV_MESSAGE_UPDATE Status :Update was terminated Err [More]
I'm working to set up my website with iWeb and it won't let me import photos from iPhoto! Whats up?Will Image capture (in your applications foldr) see them and bring to disk? If so then once they are safely off the memory card and on disk use the cam [More]
Hi Everyone, I´d like to know if there is a way to achieve the numbering presented on the second table below with only native Oracle functions, like ROW_COUNT() over partition, etc. I´m using Oracle 10g. The logic used is: Starting from 1, increment [More]
Hello. Quick question: My mobile phone calculates 100 * 10% = 10 To my iBook's Calculator 100 * 10% = 0.1 The iBook as far as I can remember used to give me the same answer as my mobile phone. How can I change this back? I have already deleted com.ap [More]
Every time since an hour ago, I'm experiencing a pop up saying Verification Required when I'm purchasing apps and ever time I verify it it says that my payment method is not valid. this never happened before. Earlier this morning I was able to downlo [More]
Having problems displaying a PDF file (very low resolution & bad contrast). So I tried IE9. When I click on the link, Firefox opens to display the PDF "Swett/Sweet", even when Firefox is not running. Page with the file "Swett/Sweet" [More]
I tried to set my alarm last night and discovered the "beep" function only works when the "clicker" is turned on. It also only beeps once, not reliable enough to wake me up. Maybe apple will change this with the next software update.Ye [More]
I am working on a BEA Weblogic application migration from 7.1 to 8.1. My application has lots of Oracle user defined package functions for providing database query. Those functions return a cursor pointing to the query results (ResultSet object in JD [More]
Despite repeated attempt to create a slide show with no audio Elements 8 picks music and applies it regardless. Is this a software bug and if so is there a patch to retify the problem? Thanks. Shoopa  If you created your slideshow using the slideshow [More]
I don't know if this is the place to put this but 2 idea's for the lil X-FI tray icon. ) How about adding a quick switch feature for modes - In other words make it so you can r-click the icon in the tray and one of the flyouts would be Mode and under [More]