No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48757 | | Total active users | 1320 | | Act. users last 24h | 0 | | Act. users last hour | 0 | | Registered user hits last week | 24 | | Registered user hits last month | 1443 |
|
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
|
|