Stored procedure hangs during compilation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Stored procedure hangs during compilation

  1. #1
    Join Date
    Mar 2000
    Location
    woodbridge,nj,USA
    Posts
    14
    DBA's

    I have come across the following problem and would
    like to know if you have a solution for it:

    When I compile the following stored procedure:
    (The procedure does nothing but demonstrate the
    situation)

    create or replace procedure test1 as

    cursor c0 is
    SELECT * from emp a where (a.deptno,a.sal) in (('10',100),('20','2000'),('30','3000'));


    begin

    dbms_output.put_line('hello world');
    end test1;

    The above cursor has 3 element pairs in the 'in' clause

    However when I increase the number of elements in the
    in clause to 4 the compilation of the procedure hangs


    create or replace procedure test2 as

    cursor c0 is
    SELECT * from emp a where (a.deptno,a.sal) in (('10',100),('20','2000'),('30','3000'),('40','4000'));


    begin

    dbms_output.put_line('hello world');
    end test2;

    Any assistance or work arounds on this problem appreciated

    Thanks
    -U-


  2. #2
    Join Date
    May 2002
    Posts
    37
    I've tried to replicate your problem, but both procedures compiled without any problems.

    what version of Oracle do you have?

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    look v$session_wait what it is waiting for

Posting Permissions

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



Click Here to Expand Forum to Full Width