Nested Table Edit working only once (14.0.0.462)

Toad for Oracle - Beta
1

When I execute the following query using F9:

SELECT NEW sys.ora_mining_number_nt( 1 ) FROM dual;

a double-click on (DATASET) opens the Nested Table Edit as expected:
image

Closing that popup and reopening displays an empty list instead:
image

Can you reproduce this? Thanks.

2

Yes, thanks. I'll fix.

3

Same with cursor

select level rn, cursor (
select level rn from dual
connect by level <= 3
) vals
from dual
connect by level <= 2;

4

Thanks for the report (and query). This will be fixed in the next beta.

1 Like
5

My example seems to work now, but I still get the same behavior for tenorios example using CURSOR.

Should both of them be fixed?

6

I know I said "next beta" but the fix wasn't made in time for 14.0.15.577. It is definitely fixed for the next one. Sorry about that.

1 Like
7

Opening the same cursor twice still shows an empty list with 14.0.33.607.
Can you confirm that?

8

The 2nd time you open it, are you opening the cursor from the same cell of the main table? In that case, It's expected to be empty, because the cursor can be fetched only once.

But now you should be able to see the first row's cursor, then the 2nd, etc.

9

Yes, that's what I tried.

Good enough for me but a warning instead of an empty list might be nice.

10

Good idea. Thanks for testing it.