No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1323
Act. users last 24h3
Act. users last hour0
Registered user hits last week79
Registered user hits last month345
Comment details
Date 30-JUL-12
Type Bug
User Bart Hendriks
Message Hello, when i run it on 10.1 db i get an error message.
when i run the plato_52_10g script everything is ok

SQL> @E:\CHECK_ORACLE\REPORTS\plato\script\plato_52_10g\plato_52_10g.sql
...
...
[Report generated in 0 seconds.]
This package expires on Aug 01, 2012
SQL>

if i run version 53 i get this result:

@E:\CHECK_ORACLE\REPORTS\plato\script\plato_53_10g\plato_53_10g.sql
This script may be run as any user.
It is recommended to run this script in SQL*Plus (due to the substitution var's)


================================================================================

== VERIFYING PREREQUISITES ... ==

================================================================================


Prerequisites ok.

Creating main package specification...
No errors.
Creating utility package...
No errors.
Creating utility package body...
No errors.
Creating stats package...
No errors.
Creating stats package body...
No errors.
Creating storage package...
No errors.
Creating storage package body...
No errors.
Creating audit package...
No errors.
Creating audit package body...

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY PLATO$GDP$AUDIT:
2305/17 PL/SQL: SQL Statement ignored
2313/26 PL/SQL: ORA-00942: table or view does not exist
2316/7 PL/SQL: Statement ignored
2316/15 PLS-00364: loop index variable 'S_REC' use is invalid
2317/7 PL/SQL: Statement ignored
2317/15 PLS-00364: loop index variable 'S_REC' use is invalid
2318/7 PL/SQL: Statement ignored
2318/15 PLS-00364: loop index variable 'S_REC' use is invalid
2319/7 PL/SQL: Statement ignored
2319/15 PLS-00364: loop index variable 'S_REC' use is invalid
2320/7 PL/SQL: Statement ignored
2320/23 PLS-00364: loop index variable 'S_REC' use is invalid
2321/7 PL/SQL: Statement ignored
2321/15 PLS-00364: loop index variable 'S_REC' use is invalid
Creating main package body...
No errors.
BEGIN plato.help; END;

*
ERROR at line 1:
ORA-04063: package body "SYS.PLATO$GDP$AUDIT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.PLATO", line 4198
ORA-06512: at line 1