Results 1 to 2 of 2

Thread: Wait one second

  1. #1
    Join Date
    May 2004
    Posts
    14

    Unanswered: Wait one second

    Dear all,

    Is there any one know how to make oracle wait n seconds in the sp.

    Eg.

    Create procedure
    begin

    insert into a values(xxx);

    wait 1 seconds; <=?????

    insert into b values(xxx);

    end;

    Regards,

    Thomas HO

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Yes:

    dbms_lock.sleep(1);

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •