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

Oracle LazyDBA home page