Zara,
Alan is a stronger than I am at the DBA side of installs - so I'd be
interested in hearing his response; however, I may be able to point
you in the right direction.
These three packages are definitely OTM specific - you can find the
package source files for each of them under <otm_install_dir>/glog/
oracle/script8/pkg. They appear to be very base functions - so it's
odd that they are failing. In order to find the specific errors, you
can run "show errors" after trying to recompile a specific package.
This will at least show you the line (plus or minus) of the package
definition that is failing. From here, you can begin troubleshooting
the root cause.
References:
Oracle Database Application Developer's Guide : http://
http://www.stanford.edu/dept/itss/do...ev.101/b10795/
adfns_pc.htm
OReily - Advanced Oracle PL/SQL :
http://www.unix.org.ua/orelly/
oracle/advprog/ch15_01.htm
Hope this helps!
Thanks!
--Chris
--
Chris Plough
OTM / GC3 Community Forums
http://www.otmfaq.com
On Dec 14, 2006, at 1:00 AM, idqpbi wrote:
> Hi,
>
> Anybody experienced this before? This is the last SQL script to run
> before I could actually start to verify my imported data. All of
> the previous scripts were OK, even the import after I took
> Stephen's advice. Sigh...... :-(
> Maybe Alan or Stephen could help again. :-)
>
> Here is what I have in the terminal window: (sorry it's kind of
> long since I ran the same scripts twice hoping to fix it)
> ----------------------------------------------------------------------
> -----------------------------------------------------------
>
> _*1st Run*_
>
> SQL> @recompile_invalid_objects.sql
>
> ORA-24344: success with compilation error
> ORA-24344: success with compilation error
> ORA-24344: success with compilation error
>
>
> List of first 50 Invalid objects after recompile.
> ================================================
> DBHEALTH PACKAGE BODY
> CREATE_TABLE PACKAGE BODY
> PKG_PURGE PACKAGE BODY
>
> Errors for PACKAGE BODY CREATE_TABLE:
> 55/23 PL/SQL: ORA-00942: table or view does not exist
>
> 55/7 PL/SQL: SQL Statement ignored
>
>
> Errors for PACKAGE BODY DBHEALTH:
> 10/14 PL/SQL: SQL Statement ignored
>
> 10/32 PL/SQL: ORA-00942: table or view does not exist
>
> 100/21 PL/SQL: ORA-00942: table or view does not exist
>
> 106/39 PLS-00364: loop index variable 'C1REC' use is invalid
>
> 120/20 PL/SQL: SQL Statement ignored
>
> 120/77 PL/SQL: ORA-00942: table or view does not exist
>
> 53/14 PL/SQL: SQL Statement ignored
>
> 53/84 PL/SQL: ORA-00942: table or view does not exist
>
> 57/39 PLS-00364: loop index variable 'C1REC' use is invalid
>
> 64/14 PL/SQL: SQL Statement ignored
>
> 64/56 PL/SQL: ORA-00942: table or view does not exist
>
> 68/40 PLS-00364: loop index variable 'C1REC' use is invalid
>
> 75/14 PL/SQL: SQL Statement ignored
>
> 75/48 PL/SQL: ORA-00942: table or view does not exist
>
> 79/44 PLS-00364: loop index variable 'C1REC' use is invalid
>
> 98/14 PL/SQL: SQL Statement ignored
>
>
> Errors for PACKAGE BODY PKG_PURGE:
> 1339/4 PL/SQL: SQL Statement ignored
>
> 1339/43 PL/SQL: ORA-00942: table or view does not exist
>
> 1910/29 PL/SQL: ORA-00942: table or view does not exist
>
> 1910/5 PL/SQL: SQL Statement ignored
>
> 1913/5 PL/SQL: SQL Statement ignored
>
> 1913/61 PL/SQL: ORA-00942: table or view does not exist
>
> 1921/8 PLS-00364: loop index variable 'JOB_PARAM_REC' use
> is invalid
>
> 1938/7 PLS-00364: loop index variable 'SO_JOB_REC' use is
> invalid
>
> 1950/15 PLS-00364: loop index variable 'SO_JOB_REC' use is
> invalid
>
>
>
> Invalid objects before Recompile....
>
> 45
>
> *Invalid objects after Recompile....
>
> 3 *
>
>
>
> Some objects have compiled successfully.
>
>
> Please re-run recompile_invalid_objects to compile the rest of
> invalid objects.
>
> _*2nd Run*_
>
> SQL> @recompile_invalid_objects.sql
>
> ORA-24344: success with compilation error
> ORA-24344: success with compilation error
> ORA-24344: success with compilation error
>
>
> List of first 50 Invalid objects after recompile.
> ================================================
> DBHEALTH PACKAGE BODY
> CREATE_TABLE PACKAGE BODY
> PKG_PURGE PACKAGE BODY
>
> *Errors for PACKAGE BODY CREATE_TABLE: *
> 55/23 PL/SQL: ORA-00942: table or view does not exist
>
> 55/7 PL/SQL: SQL Statement ignored
>
>
> *Errors for PACKAGE BODY DBHEALTH: *
> 10/14 PL/SQL: SQL Statement ignored
>
> 10/32 PL/SQL: ORA-00942: table or view does not exist
>
> 100/21 PL/SQL: ORA-00942: table or view does not exist
>
> 106/39 PLS-00364: loop index variable 'C1REC' use is invalid
>
> 120/20 PL/SQL: SQL Statement ignored
>
> 120/77 PL/SQL: ORA-00942: table or view does not exist
>
> 53/14 PL/SQL: SQL Statement ignored
>
> 53/84 PL/SQL: ORA-00942: table or view does not exist
>
> 57/39 PLS-00364: loop index variable 'C1REC' use is invalid
>
> 64/14 PL/SQL: SQL Statement ignored
>
> 64/56 PL/SQL: ORA-00942: table or view does not exist
>
> 68/40 PLS-00364: loop index variable 'C1REC' use is invalid
>
> 75/14 PL/SQL: SQL Statement ignored
>
> 75/48 PL/SQL: ORA-00942: table or view does not exist
>
> 79/44 PLS-00364: loop index variable 'C1REC' use is invalid
>
> 98/14 PL/SQL: SQL Statement ignored
>
>
> *Errors for PACKAGE BODY PKG_PURGE: *
> 1339/4 PL/SQL: SQL Statement ignored
>
> 1339/43 PL/SQL: ORA-00942: table or view does not exist
>
> 1910/29 PL/SQL: ORA-00942: table or view does not exist
>
> 1910/5 PL/SQL: SQL Statement ignored
>
> 1913/5 PL/SQL: SQL Statement ignored
>
> 1913/61 PL/SQL: ORA-00942: table or view does not exist
>
> 1921/8 PLS-00364: loop index variable 'JOB_PARAM_REC' use
> is invalid
>
> 1938/7 PLS-00364: loop index variable 'SO_JOB_REC' use is
> invalid
>
> 1950/15 PLS-00364: loop index variable 'SO_JOB_REC' use is
> invalid
>
>
>
> Invalid objects before Recompile....
>
> 3
>
> *Invalid objects after Recompile....
>
> 3 *
>
>
>
> The number of invalid objects is still the same after recompile.
>
>
> Please analyze the existing invalid objects.
>
> SQL>
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> -------------------
>
> The only thing I could think of was I failed to grant execute
> permission on "dbms_rls", "dbms_aqin" and "dbms_pipe" when running
> the "create_glog_users.sql" script. So I ended up connecting as SYS
> user instead and manually ran those four statements. However it
> does not look like that would cause these invalid
> objects...........My head is going to explode, I think.
>
> Thanks in advance for any help!!
>
> Zara
>
> You are receiving this mail as a subscriber of the Oracle
> Transportation
> Management SIG List Server. This list is provided by Solution Beacon,
> LLC for the Oracle Transportation Management SIG to facilitate
> distribution
> of issues and topics related to Oracle Transportation Management.
> If you
> do not want to receive future mail from the list, send email to
> majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe
> otmsig" (without
> quotes) in the body of the email.
> If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
> Thank you!
You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!
Linear Mode
