Help trying to debug this DUMB pl/sql code

Giganews Newsgroups
Subject: Help trying to debug this DUMB pl/sql code
Posted by:  amer…@iwc.net (amer…@iwc.net)
Date: Mon, 05 Nov 2007

Hi,

I have a package I'm trying to run through a debugger and find some
weird error.  The package uses a defined type VARRAY:

TYPE IN_STR_ARR IS VARRAY(500) OF VARCHAR2(500);

The package has a number of parameters it accepts:

PROCEDURE awi_report_php (
  p_site_id      NUMBER,
  p_i            IN OUT IN_STR_ARR,
  p_o            IN OUT IN_STR_ARR,
  p_v            IN OUT IN_STR_ARR,
  p_columns      IN OUT IN_STR_ARR,
  line      OUT TEST_CURSOR,
  p_str      OUT VARCHAR2,
  p_save_out OUT VARCHAR2,
  p_save_in      VARCHAR2 DEFAULT NULL,
  p_comp_id      VARCHAR2 DEFAULT NULL,
  p_customer_id  VARCHAR2 DEFAULT NULL);

Anyhow, if I try to debug with TOAD, I get some error about it not
being able to find the TYPE.
If I try to debug using SQL Developer, it complains about some 6531
error regarding an uninitialized collection.

WTF?  This thing runs without any debugger (though it has an
error).

Can anyone think of anything???

Thanks!

Replies