Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Request for test help
Frank van Bortel wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Windows 32-bit, 10.2.0.3.0 + latest CPU patch - same:
> SQL> SELECT dbms_undo_adv.undo_advisor(35,44,1) from dual;
> SELECT dbms_undo_adv.undo_advisor(35,44,1) from dual
> *
> ERROR at line 1:
> ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
> ORA-06512: at "SYS.PRVT_ADVISOR", line 3895
> ORA-14551: cannot perform a DML operation inside a query
> ORA-06512: at "SYS.DBMS_UNDO_ADV", line 703
> ORA-06512: at "SYS.DBMS_UNDO_ADV", line 752
>
> That should be enough environments not to make it
> a platform dependent bug.
>
> Could give you same version on HP-UX Itaniuum if wanted.
>
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
>
> iD8DBQFGmLbwLw8L4IAs830RAv37AJ9MTurdEJHRI8RcuMGsHPy0ThWYggCfWjlW
> JGtrgpBdtkvSos4HJoC2BlI=
> =BYV0
> -----END PGP SIGNATURE-----
Thanks but I think that does it unless someone has 10gR1 anywhere?
My suspicion is that it never worked in any version on any platform.
Thanks again everyone.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Jul 14 2007 - 08:26:58 CDT
![]() |
![]() |