INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

...I enjoy spending time on it for personal growth (I learn from the questions I don't answer, and I reinforce/stay sharp on the topics I do answer), and to give back to humanity at large...

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Oracle: Oracle release - 9i and earlier Forum

Export error - dbms_xmlgen(2)

Read More Threads Like This One

rurrutia (MIS)

18 Dec 08 14:41

Hi guys
Ive inherited a DB with some porblems during export, when export is run the following message appears

EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_XMLGEN" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_METADATA", line 345
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 1156
ORA-06512: at "SYS.DBMS_METADATA", line 1141
ORA-06512: at line 1

Indeed the mentioned package body does not exist, but since its wrapped I cannot see code to create and edit its content, I also cannot find a sql to create it

How can I add this packg body?

Thanks

SantaMufasa (TechnicalUser)

18 Dec 08 15:03

rurrutia,

My choices are "Give a Man a Fish" or "Teach a Man to Fish". If I were to "Give a Man a Fish", I would Google for something like, "recreate DBMS_XMLGEN" and post the best suggestion here.

Since I must deliver my wife to a doctor's appointment, I must "Teach a man to Fish" by suggesting that you Google for the above.

Once you Google and test a worthwhile answer, please post here and advise us your findings. (Doing so will probably earn you a

<grin>)

santa Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
"Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty."

(2) karluk (MIS)

18 Dec 08 15:06

You have to recreate the DBMS_XMLGEN package. You, or someone in your shop with the appropriate permissions, needs to log into the database server and connect to your database as sys. Then, according to Metalink note 565166.1, you should run the followin in sql*plus:

CODE

@?/rdbms/admin/dbmsxml.sql
@?/rdbms/admin/prvtxml.plb
alter package SYS.DBMS_XMLGEN compile body;
alter package SYS.DBMS_METADATA compile body;

SantaMufasa (TechnicalUser)

18 Dec 08 15:09

Who needs Google when you have KarlUK? <grin> Hava

, Karl.

rurrutia (MIS)

18 Dec 08 17:57

Thanks for the fish karluk, it worked great
I've already tried dbmsxml.sql before, not prvtxml.plb
My Metalink account has another person as admin

Merry XMAS

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Oracle: Oracle release - 9i and earlier