Re: Workspace Manager Question

On 1 Aug 2006 09:08:27 -0700, "wrgptfan" <wrgptfan_at_hotmail.com> wrote:

>permit_at_devdb> exec dbms_wm.BeginDDL('WCP_ISSUING_LOCATION_CODE');
>BEGIN dbms_wm.BeginDDL('WCP_ISSUING_LOCATION_CODE'); END;
>
>*
>ERROR at line 1:
>ORA-00972: identifier is too long
>ORA-06512: at "SYS.OWM_DDL_PKG", line 1878
>ORA-06512: at "SYS.LT", line 10257
>ORA-06512: at line 1
>
>
>permit_at_devdb> select * from v$version;
>
>BANNER
>----------------------------------------------------------------
>Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
>PL/SQL Release 9.2.0.5.0 - Production
>CORE 9.2.0.6.0 Production
>TNS for HPUX: Version 9.2.0.5.0 - Production
>NLSRTL Version 9.2.0.5.0 - Production
>
>permit_at_devdb>

alter session set events='972 trace name dump errorstack, level 3' prior to running the pl/sql
will dump the exact statement in error in a trace file in user_dump_dest on the server

Hth

--
Sybrand Bakker, Senior Oracle DBA