Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122

    Unanswered: BULK COLLECT debugging?

    What is the best way to debug pl/sql code that uses BULK COLLECT?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I guess the same as any PL/SQL block ... if you use a tool like TOAD, run your script through debugger. If in SQL*Plus, use DBMS_OUTPUT.PUT_LINEs.

    What difference does BULK COLLECT make? If it fails, perhaps the INTO variables aren't correctly declared?

  3. #3
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122

    Thanks Littlefoot

    That was it, I was using the wrong variables in my dbms_output lines . I'm still having problems but making progress.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Well, Rome wasn't built in a day either.

Posting Permissions

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