Re: Help trying to debug this DUMB pl/sql code

On Nov 5, 12:13 pm, "ame...@xxxxxxx" <ame...@xxxxxxx> wrote:
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!



Can I add, that I am explicitly assigning values to each of the
elements.......


.

Relevant Pages

  • Re: Help trying to debug this DUMB pl/sql code
    ... I have a package I'm trying to run through a debugger and find some ... The package uses a defined type VARRAY: ... p_save_out OUT VARCHAR2, ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)
  • Re: Package debugging
    ... find information about the best way to debug a package. ... capable of debugging procedures that are not part of a package. ... SQL Developer has a very nice debugger, ...
    (comp.databases.oracle.tools)
  • Re: Help trying to debug this DUMB pl/sql code
    ... I have a package I'm trying to run through a debugger and find some ... The package uses a defined type VARRAY: ... p_save_out OUT VARCHAR2, ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)
  • Re: Debug API in the core?
    ... way to use and test them from Tcl, without needing a debugger ... extension... ... not such a bad thing to need to say [package require debug] though. ...
    (comp.lang.tcl)
  • Help trying to debug this DUMB pl/sql code
    ... I have a package I'm trying to run through a debugger and find some ... The package uses a defined type VARRAY: ... p_save_out OUT VARCHAR2, ... If I try to debug using SQL Developer, ...
    (comp.databases.oracle.server)