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




Oracle LazyDBA home page