Re: In doubt distributed transactions

I have re-run dbmsutil.sql and prvtutil.plb which contain the creation of dbms_transaction package.
During the upgrade I had re-run the catalog SQL scripts . The oracle version I have now is 7.3.4.2.

In article <921228119.4895.0.nnrp-06.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> Is it possible that the database has been
> upgraded from one version of Oracle to
> another and some of the catalog SQL scripts
> have not been run ?
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> yewpc_at_my-dejanews.com wrote in message <7cahop$o0g$1_at_nnrp1.dejanews.com>...
> >Hi,
> >
> >I try to :
> > execute dbms_transaction.purge_lost_db_entry(global_txn_id);
> >
> >if i execute it using sys user I get the following error :
> >ERROR at line 1:
> >ORA-06510: PL/SQL: unhandled user-defined exception
> >ORA-06512: at "SYS.DBMS_TRANSACTION", line 94
> >ORA-06512: at line 1
> >
> >
> >if i execute it using system user i get different error :
> >ERROR at line 1:
> >ORA-00942: table or view does not exist
> >ORA-06512: at "SYS.DBMS_TRANSACTION", line 86
> >ORA-06512: at line 1
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 21:40:37 CST