Yes, in your Oracle_home/admin directory you should have a file named:
dbmslock.sql. Run that as sys, then grant execute on the procedure
"dbms_lock" to the user(s) (not the roles) who need to be able to
execute it.
-----Original Message-----
From: Terry Moutray
[mailto:oracledba-ezmlmshield-x35442201.[Email address protected]
Sent: Friday, February 29, 2008 9:49 AM
To: LazyDBA Discussion
Subject: RE: SwingBench...
Hi:
Another suggestion that I received was that I should recompile the
package
body, not just the package.
I did so in OEM and that is where the error resides -> in a procedure:
procedure sleep(min_sleep integer, max_sleep integer) is
sleeptime number := 0;
begin
if (((max_sleep - min_sleep) > 0) AND (min_sleep < max_sleep))
then
sleeptime := dbms_random.value(from_mills_to_secs(min_sleep),
from_mills_to_secs(max_sleep));
dbms_lock.sleep(sleeptime);
end if;
info_array(SLEEP_TIME) := (sleeptime * 1000) +
info_array(SLEEP_TIME);
end sleep;
The errors flagged are:
Line # = 67 Column # = 9 Error Text = PL/SQL: Statement ignored
Line # = 67 Column # = 9 Error Text = PLS-00201: identifier 'DBMS_LOCK'
must
be declared
Which equates to the "dbms_lock.sleep(sleeptime);" statement.
Any suggestions? Is this "dbms_lock" something that should be created
by
one of the auxillary sql scripts in rdbms/admin? If so, which one?
Thanks
Terry
-------Original Message-------
From: Terry Moutray
Date: 2/28/2008 7:14:59 PM
To: LazyDBA Discussion
Subject: RE: SwingBench...
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
THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.
Oracle LazyDBA home page