Re: Help trying to debug this DUMB pl/sql code
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Mon, 05 Nov 2007 18:48:46 -0800
amerar@xxxxxxx wrote:
On Nov 5, 1:35 pm, gerryt <lepsys...@xxxxxxxxx> wrote:On Nov 5, 11:04 am, "fitzjarr...@xxxxxxx" <fitzjarr...@xxxxxxx> wrote:
On Nov 5, 12:19 pm, "ame...@xxxxxxx" <ame...@xxxxxxx> wrote:Thinking of plonking another toadie, yes : >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???
As he's been posting here since 2002 and still doesnt get it I thinkCan I add, that I am explicitly assigning values to each of theCan we add that you regularly pull this stunt (not providing any
elements.......- Hide quoted text -
- Show quoted text -
useful information, such as Oracle version [all four numbers], actual
code, actual error message) and expect someone to possess a crystal
ball to assist you?
Can YOU add the missing information?
you are
being optimistic : >
I think your parents abused you both as children.......
What you think may be important to you. What I know is that I've
kill-filed you and you will no longer receive any help from me.
I think everyone else, based on your abusive attitude, should also
consider making your an internet orphan.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- References:
- Help trying to debug this DUMB pl/sql code
- From: amerar@xxxxxxx
- Re: Help trying to debug this DUMB pl/sql code
- From: amerar@xxxxxxx
- Re: Help trying to debug this DUMB pl/sql code
- From: fitzjarrell@xxxxxxx
- Re: Help trying to debug this DUMB pl/sql code
- From: gerryt
- Re: Help trying to debug this DUMB pl/sql code
- From: amerar@xxxxxxx
- Help trying to debug this DUMB pl/sql code
- Prev by Date: Re: Significant virtual memory paging was detected on the host operating system
- Next by Date: Re: Increasing memory granted to user
- Previous by thread: Re: Help trying to debug this DUMB pl/sql code
- Next by thread: Increasing memory granted to user
- Index(es):
Relevant Pages
|
