CREATE OR REPLACE PROCEDURE QUEST.OW_DEBUG_COLL
AS
i INTEGER;
TYPE prometi_t IS TABLE OF OW_customers%ROWTYPE
INDEX BY PLS_INTEGER;
prometi_col prometi_t;
BEGIN
SELECT *
BULK COLLECT
INTO prometi_col
FROM ow_customers;
FOR i IN prometi_col.FIRST .. prometi_col.LAST
LOOP
prometi_col (i).operater := 'Jazst osebno';
END LOOP;
END ow_debug_coll;
/
If I put watch on collection prometi_col I see only the value of counter
i. The official Quest Support explanation is that this is because
of limitations in DBMS_DEBUGG package, but I have info from my customers
that there is no problems if you are using free ORACLE's
SQL Developer.
Oracle is 10gR2
TOAD 10.1.1.8
Regards!
P.S. Of course I have turned on 'Enable Smart Watches'
Hi there.
Why I am not able to debug simple procedure like:
CREATE OR REPLACE PROCEDURE QUEST.OW_DEBUG_COLL
AS
i INTEGER;
TYPE prometi_t IS TABLE OF OW_customers%ROWTYPE
INDEX BY PLS_INTEGER;
prometi_col prometi_t;
BEGIN
SELECT *
BULK COLLECT
INTO prometi_col
FROM ow_customers;
FOR i IN prometi_col.FIRST .. prometi_col.LAST
LOOP
prometi_col (i).operater := 'Jazst osebno';
END LOOP;
END ow_debug_coll;
/
If I put watch on collection prometi_col I see only the value of counter i. The
official Quest Support explanation is that this is because
of limitations in DBMS_DEBUGG package, but I have info from my customers that
there is no problems if you are using free ORACLE's
SQL Developer.
Oracle is 10gR2
TOAD 10.1.1.8
Regards!
P.S. Of course I have turned on 'Enable Smart Watches'
You can switch to using the JDWP debugger in TOAD options – which is what
SQL Developer uses by default. The debugger will look and behave exactly the
same (maybe a little slower) as TOAD will simply be calling a different debug
engine (API) under the covers …..
Aci,
Oracle uses JDWP for debugging and Toad uses DBMS which has many
limitations. Because SQL developer is a native java app, it has the
ability to view complex variables. Unfortunatly, the DBMS_DEBUG API
does not. We do have a JDWP debugger but because Toad is not a native
java app, we don't have the ability to fully support all the
capabilities of the JDWP API.
Greg
On Mar 11, 2010, at 6:25 AM, "Aci Polajnar" wrote:
Hi there.
Why I am not able to debug simple procedure like:
CREATE OR REPLACE PROCEDURE QUEST.OW_DEBUG_COLL
AS
i INTEGER;
TYPE prometi_t IS TABLE OF OW_customers%ROWTYPE
INDEX BY PLS_INTEGER;
prometi_col prometi_t;
BEGIN
SELECT *
BULK COLLECT
INTO prometi_col
FROM ow_customers;
FOR i IN prometi_col.FIRST .. prometi_col.LAST
LOOP
prometi_col (i).operater := 'Jazst osebno';
END LOOP;
END ow_debug_coll;
/
If I put watch on collection prometi_col I see only the value of
counter i. The official Quest Support explanation is that this is
because
of limitations in DBMS_DEBUGG package, but I have info from my
customers that there is no problems if you are using free ORACLE's
SQL Developer.
Oracle is 10gR2
TOAD 10.1.1.8
Regards!
P.S. Of course I have turned on 'Enable Smart Watches'
Thank you, Bert, for answering but I am not able to switch as my TOAD
simply stops in case of JDWP Debugger.
Do I need some Java or ORACLE things or my 64bit Vista is not compatibel
with this things??
Regards!
Bert Scalzo wrote:
You can switch to using the JDWP debugger in TOAD options -- which is
what SQL Developer uses by default. The debugger will look and behave
exactly the same (maybe a little slower) as TOAD will simply be
calling a different debug engine (API) under the covers .....
CREATE OR REPLACE PROCEDURE QUEST.OW_DEBUG_COLL
AS
i INTEGER;
TYPE prometi_t IS TABLE OF OW_customers%ROWTYPE
INDEX BY PLS_INTEGER;
prometi_col prometi_t;
BEGIN
SELECT *
BULK COLLECT
INTO prometi_col
FROM ow_customers;
FOR i IN prometi_col.FIRST .. prometi_col.LAST
LOOP
prometi_col (i).operater := 'Jazst osebno';
END LOOP;
END ow_debug_coll;
/
If I put watch on collection prometi_col I see only the value of
counter i. The official Quest Support explanation is that this is because
of limitations in DBMS_DEBUGG package, but I have info from my
customers that there is no problems if you are using free ORACLE's
SQL Developer.
Oracle is 10gR2
TOAD 10.1.1.8
Regards!
P.S. Of course I have turned on 'Enable Smart Watches'
--
__________ Information from ESET Smart Security, version of virus
signature database 4934 (20100311) __________
Thank you, Bert, for answering but I am not able to switch as my TOAD simply
stops in case of JDWP Debugger.
Do I need some Java or ORACLE things or my 64bit Vista is not compatibel with
this things??
Regards!
Bert Scalzo wrote:
You can switch to using the JDWP debugger in TOAD options – which is
what SQL Developer uses by default. The debugger will look and behave
exactly the same (maybe a little slower) as TOAD will simply be calling a
different debug engine (API) under the covers …..
Thank you, Bert, for answering but I am not able to switch as my TOAD
simply stops in case of JDWP Debugger.
Do I need some Java or ORACLE things or my 64bit Vista is not compatibel
with this things??
Regards!
Bert Scalzo wrote:
You can switch to using the JDWP debugger in TOAD options -- which is
what SQL Developer uses by default. The debugger will look and behave
exactly the same (maybe a little slower) as TOAD will simply be
calling a different debug engine (API) under the covers .....
CREATE OR REPLACE PROCEDURE QUEST.OW_DEBUG_COLL
AS
i INTEGER;
TYPE prometi_t IS TABLE OF OW_customers%ROWTYPE
INDEX BY PLS_INTEGER;
prometi_col prometi_t;
BEGIN
SELECT *
BULK COLLECT
INTO prometi_col
FROM ow_customers;
FOR i IN prometi_col.FIRST .. prometi_col.LAST
LOOP
prometi_col (i).operater := 'Jazst osebno';
END LOOP;
END ow_debug_coll;
/
If I put watch on collection prometi_col I see only the value of
counter i. The official Quest Support explanation is that this is because
of limitations in DBMS_DEBUGG package, but I have info from my
customers that there is no problems if you are using free ORACLE's
SQL Developer.
Oracle is 10gR2
TOAD 10.1.1.8
Regards!
P.S. Of course I have turned on 'Enable Smart Watches'
--
__________ Information from ESET Smart Security, version of virus
signature database 4934 (20100311) __________
Thank you, Bert, for answering but I am not able to switch as my TOAD simply
stops in case of JDWP Debugger.
Do I need some Java or ORACLE things or my 64bit Vista is not compatibel with
this things??
Regards!
Bert Scalzo wrote:
You can switch to using the JDWP debugger in TOAD options – which is
what SQL Developer uses by default. The debugger will look and behave
exactly the same (maybe a little slower) as TOAD will simply be calling a
different debug engine (API) under the covers ….. acip.vcf (298 Bytes)
Thank you, Bert, for answering but I am not able to switch as my TOAD
simply stops in case of JDWP Debugger.
Do I need some Java or ORACLE things or my 64bit Vista is not compatibel
with this things??
Regards!
Bert Scalzo wrote:
You can switch to using the JDWP debugger in TOAD options -- which is
what SQL Developer uses by default. The debugger will look and behave
exactly the same (maybe a little slower) as TOAD will simply be
calling a different debug engine (API) under the covers .....
CREATE OR REPLACE PROCEDURE QUEST.OW_DEBUG_COLL
AS
i INTEGER;
TYPE prometi_t IS TABLE OF OW_customers%ROWTYPE
INDEX BY PLS_INTEGER;
prometi_col prometi_t;
BEGIN
SELECT *
BULK COLLECT
INTO prometi_col
FROM ow_customers;
FOR i IN prometi_col.FIRST .. prometi_col.LAST
LOOP
prometi_col (i).operater := 'Jazst osebno';
END LOOP;
END ow_debug_coll;
/
If I put watch on collection prometi_col I see only the value of
counter i. The official Quest Support explanation is that this is because
of limitations in DBMS_DEBUGG package, but I have info from my
customers that there is no problems if you are using free ORACLE's
SQL Developer.
Oracle is 10gR2
TOAD 10.1.1.8
Regards!
P.S. Of course I have turned on 'Enable Smart Watches'
--
__________ Information from ESET Smart Security, version of virus
signature database 4934 (20100311) __________
Thank you, Bert, for answering but I am not able to switch as my TOAD simply
stops in case of JDWP Debugger.
Do I need some Java or ORACLE things or my 64bit Vista is not compatibel with
this things??
Regards!
Bert Scalzo wrote:
You can switch to using the JDWP debugger in TOAD options – which is
what SQL Developer uses by default. The debugger will look and behave
exactly the same (maybe a little slower) as TOAD will simply be calling a
different debug engine (API) under the covers ….. att1.dat (73.2 KB)
I believe that Jeff Smith wrote either a paper or blog on ToadWorld ( www.toadworld.com ) about using the debugger that covers some issues like this.
I’d start there for instructions and/or ideas on how to do so ….
If you can get it going with SQL Developer, you shouldn’t have any issues
getting it going with Toad.
The one ‘trick’ is in the JDWP setup, you have to set the host to
YOUR machine. That’s right, you connect to Oracle, then Oracle connects
BACK to your machine to do the debugging. So you want to make sure the port
you’re using isn’t blocked by firewall.
If you’re going to be doing a lot of work with collections, I’d
suggest you just go ahead and use SQL Developer to debug those
procs…however, in the beta we’re working on a new simpler
‘debugger’ that will dynamically send everything to DBMS_OUTPUT
which you may find useful.
If you can get it going with SQL Developer, you shouldn’t have any issues
getting it going with Toad.
The one ‘trick’ is in the JDWP setup, you have to set the host to
YOUR machine. That’s right, you connect to Oracle, then Oracle connects
BACK to your machine to do the debugging. So you want to make sure the port
you’re using isn’t blocked by firewall.
If you’re going to be doing a lot of work with collections, I’d
suggest you just go ahead and use SQL Developer to debug those
procs…however, in the beta we’re working on a new simpler
‘debugger’ that will dynamically send everything to DBMS_OUTPUT
which you may find useful.
It seems that the post by Greg which probably answers his question has been lost
in the flurry of posts that have followed. I’d look at Greg’s post,
Aci as you may be out of luck in this case.
It seems that the post by Greg which probably answers his question has
been lost in the flurry of posts that have followed. I'd look at
Greg's post, Aci as you may be out of luck in this case.
Yes I agree. Thanks everyone trying to help
Regards!
Michael Staszewski wrote:
It seems that the post by Greg which probably answers his question has been
lost in the flurry of posts that have followed. I’d look at
Greg’s post, Aci as you may be out of luck in this case. att1.dat (73.2 KB)
It seems that the post by Greg which probably answers his question has
been lost in the flurry of posts that have followed. I'd look at
Greg's post, Aci as you may be out of luck in this case.
Yes I agree. Thanks everyone trying to help
Regards!
Michael Staszewski wrote:
It seems that the post by Greg which probably answers his question has been
lost in the flurry of posts that have followed. I’d look at
Greg’s post, Aci as you may be out of luck in this case.
It seems that the post by Greg which probably answers his question has
been lost in the flurry of posts that have followed. I'd look at
Greg's post, Aci as you may be out of luck in this case.
Yes I agree. Thanks everyone trying to help
Regards!
Michael Staszewski wrote:
It seems that the post by Greg which probably answers his question has been
lost in the flurry of posts that have followed. I’d look at
Greg’s post, Aci as you may be out of luck in this case. acip.vcf (298 Bytes)