You can't put an anonymous PL/SQL block in the DDL...

2007-05-29T00:23:00.000+01:00

You can't put an anonymous PL/SQL block in the DDL model, but you can call a PL/SQL procedure - either one supplied by Oracle, or written by yourself.
In PT8.47 and earlier, you cannot call DBMS_STATS.GATHER_TABLE_STATS directly because [TBNAME] contains both the schema and table name and must be separated. In PT8.48 the schema name moves to [DBNAME], and [TBNAME] contains only the table name. A different version of the wrapper is required. You can download wrapper.sql as a part of the code examples for PeopleSoft for the Oracle DBA (if you have the book see page 122).
The wrapper in the book does not handle the exception raised when analysing a table with locked statistics. I'll leave that as a exercise.

OK. I understand the package that you have create...

2007-05-25T17:51:00.000+01:00

OK. I understand the package that you have created.... and you can't put a PL/SQL block in DDL model
but what do we put into the PSDDLMODEL to call this new procedure ? We are 10G and 8.47.03 of Tools.

Comments on The PeopleSoft DBA Blog: %UpdateStats() -v- Optimizer Dynamic Sampling

You can't put an anonymous PL/SQL block in the DDL...

OK. I understand the package that you have create...