Help in debugging this procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help in debugging this procedure

  1. #1
    Join Date
    May 2006
    Posts
    51

    Help in debugging this procedure

    Can any one help with this error ORA 24338: Statement Handle not executed

    /

    Thanks in advance
    Last edited by vision; 08-13-2006 at 08:17 PM.

  2. #2
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    51
    I'm not sure that this is the only problem (couldn't try your example out without a table to test against...) but it looks like you forgot to declare the rpt_cur cursor. You open it at the bottom with:

    OPEN rpt_cur
    FOR
    SELECT *
    FROM TABLE (CAST (l_data AS rpt_dpc_rec1_table_type));

    but never declared it.
    ____________________
    Pete

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