Another good program that can show errors by default is Aqua Data
Studio.
Lawrence Traub, DBA
972-820-3798
4120 International Parkway
Carrollton, TX. 75007
-----Original Message-----
From: Terance W. Ebert
[mailto:oracledba-ezmlmshield-x2301754.[Email address protected]
Sent: Thursday, February 28, 2008 6:32 PM
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
This message is intended only for the use of the individual(s) or entity to which it is addressed and may contain information that is privileged, confidential, and/or proprietary to RealPage and its affiliated companies. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, forwarding or copying of this communication is prohibited without the express permission of the sender. If you have received this communication in error, please notify the sender immediately and delete the original message.
Oracle LazyDBA home page