Thanks for the suggestion - I tried recompiling and then showing the
error(s), no luck...
SQL> alter package soe.orderentry compile;
Warning: Package altered with compilation errors.
SQL> show errors
No errors.
I can't use TOAD and it is not a RAC database (standalone).
I pulled up the package in OEM - it shows as status of valid but when I
execute
select owner, object_name from dba_objects where status = 'INVALID'
It comes back with this package listed.
I tried compiling it in OEM also and it just states that it compiled
successfully - no errors listed here either.
-------Original Message-------
From: Terance W. Ebert
Date: 02/28/08 18:32:43
To: LazyDBA Discussion
Subject: RE: SwingBench...
When you compile it manually and it says compiled with errors, you enter
show errors" and hopefully you can see the errors. Otherwise use
sqldeveloper or toad and it will show you the errors. You can also see the
errors using OEM, DBCONTROL, or GRID CONTROL
-----Original Message-----
From: Terry Moutray [mailto:oracledba-ezmlmshield-x44841424.[Email address
protected]
Sent: Thursday, February 28, 2008 3:41 PM
To: LazyDBA Discussion
Subject: SwingBench...
Has anyone tried using a load tool called SwingBench available @ http://www
Dominicgiles.com/swingbench.HTML?
I tried using it - it requires that I create a data & index tablespace; a
User; and the schema (tables, index, constraints, packages, functions, etc)
For a order inventory system.
Everything appeared to be successfully installed but it doesn't work. I did
A little investigation and it appears that the main package called
ORDERENTRY is invalid. I tried compiling it manually but it comes back with
compiled with errors" and is still invalid.
Unfortunately, it doesn't tell me what the errors are. And, even if it did,
I don't know PL/SQL so I couldn't debug and resolve this problem but if it
Told me that the package referenced something that it could not find - I
Could at least go out and check to see if that object / package / function
(whatever) existed and try to get it created using the source SQL.
It is a very large package so I didn't necessarily want to include it in
This e-mail. I was just wondering if anyone else ran into this same problem
And figured out how to resolve it.
I did try contacting the developer a few days ago but he has not replied
Back yet.
Regards
Terry Moutray
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.HTML
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.HTML
Oracle LazyDBA home page