Home > Uncategorized > Strange procedure executions, and dbms_lock.sleep(7)

Strange procedure executions, and dbms_lock.sleep(7)


I had executed a number of procedures (approx. 80) from TOAD as follows:

exec <schema_name>.<procedure name>;

exec <schema_name>.<procedure name>;

exec <schema_name>.<procedure name>;

Although it says as:

PL/SQL procedure successfully completed.

It does not. Because the tables that must be accumulated by those procedures are empty. For this reason I tried it in SQL*Plus, but it does not work either. After then, I put the executions of the procedures in a PL/SQL block with dbms_lock.sleep(3) as follows:

begin
<schema_name>.<procedure name>;

dbms_lock.sleep(3);

<schema_name>.<procedure name>;

dbms_lock.sleep(3);

<schema_name>.<procedure name>;

 Then it worked!

I amcurrently using, Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit on a ia64 hp server rx4640 box.

Advertisements
Categories: Uncategorized Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: