Toad for Oracle Beta Program Community

Toad for Oracle - Beta Forum

wickliffe.larry
Follow / 8 Mar 2018 at 4:59pm / Toad for Oracle Beta Program
Latest post by on 16 Apr 2018 at 2:12pm

TOAD 13.0.0.57 Generate Data produces invalid SQL to generate dat...

Expand content
Good Morning TOAD Team, I've been using TOAD to populate data for many tables in a new system. I recently upgraded to 13.0.0.57 and the SQL TOAD Generate Data creates is invalid. The SQL created...

Good Morning TOAD Team,

       I've been using TOAD to populate data for many tables in a new system.  I recently upgraded to 13.0.0.57 and the SQL TOAD Generate Data creates is invalid.  The SQL created is attached (how do I attach files, now?  I'll simply copy and paste below).  I plan to return to TOAD 12.11 to populate this table while you resolve the bug.

/************************************************************
** Table: CMS.CMS_GRANT
** Number of Records: 100
************************************************************/

DECLARE
SUBTYPE MAXVARCHAR2 IS VARCHAR2(32767);
TYPE Used_Array IS TABLE OF MAXVARCHAR2 INDEX BY MAXVARCHAR2;
TYPE GRANTID_Array IS TABLE OF CMS.CMS_GRANT.GRANT_ID%TYPE INDEX BY PLS_INTEGER;
TYPE GRANTNUMBER_Array IS TABLE OF CMS.CMS_GRANT.GRANT_NUMBER%TYPE INDEX BY PLS_INTEGER;
l_GRANTID GRANTID_Array;
l_GRANTID_Used Used_Array;
v_GRANTID CMS.CMS_GRANT.GRANT_ID%TYPE;
l_GRANTNUMBER GRANTNUMBER_Array;
l_GRANTNUMBER_Used Used_Array;
v_GRANTNUMBER CMS.CMS_GRANT.GRANT_NUMBER%TYPE;
t_seed NUMBER(20);
t_exists BOOLEAN;
BEGIN
-- Initialize Random Number Generator
SELECT TO_NUMBER(TO_CHAR(SYSDATE, 'MMDDHH24MISS'))
INTO t_seed
FROM Dual;

DBMS_RANDOM.INITIALIZE(t_seed);

-- Bulk Collect existing values into arrays
SELECT GRANT_ID BULK COLLECT INTO l_GRANTID FROM CMS.CMS_GRANT;
FOR t_counter IN 1..l_GRANTID.COUNT LOOP
l_GRANTID_Used(TO_CHAR(l_GRANTID(t_counter))) := TO_CHAR(l_GRANTID(t_counter));
END LOOP;

SELECT GRANT_NUMBER BULK COLLECT INTO l_GRANTNUMBER FROM CMS.CMS_GRANT;
FOR t_counter IN 1..l_GRANTNUMBER.COUNT LOOP
l_GRANTNUMBER_Used(TO_CHAR(l_GRANTNUMBER(t_counter))) := TO_CHAR(l_GRANTNUMBER(t_counter));
END LOOP;

-- Generate Random Data
FOR t_counter IN 1..100 LOOP

-- Generate random value for GRANT_ID and compare against existing list
LOOP
v_GRANTID := CMS.CMS_GRANT_SQ.NextVal;
t_exists := l_GRANTID_Used.EXISTS(TO_CHAR(v_GRANTID));

IF NOT t_exists THEN
l_GRANTID_Used(TO_CHAR(v_GRANTID)) := TO_CHAR(v_GRANTID);
END IF;

EXIT WHEN (NOT t_exists);
END LOOP;

-- Generate random value for GRANT_NUMBER and compare against existing list
LOOP
v_GRANTNUMBER := (SELECT GRANT_NUMBER FROM (SELECT GRANT_NUMBER FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1);
t_exists := l_GRANTNUMBER_Used.EXISTS(TO_CHAR(v_GRANTNUMBER));

IF NOT t_exists THEN
l_GRANTNUMBER_Used(TO_CHAR(v_GRANTNUMBER)) := TO_CHAR(v_GRANTNUMBER);
END IF;

EXIT WHEN (NOT t_exists);
END LOOP;

INSERT INTO CMS.CMS_GRANT (
GRANT_ID, PROGRAM_ID, GRANTEE_ID, CLASS_ID, SCHOOL_TYPE_ID, GRANT_NUMBER, BEGIN_DATE,
ENROLLMENT_GOALS, FISCAL_YEAR, FEDERAL_PROGRAM_OFFICER_EMAIL, IS_CONSTRUCTION_PLUS_GRANTEE,
MODIFIED_DATE, MODIFIED_BY, CREATED_DATE, CREATED_BY, IS_DELETED
) VALUES (
v_GRANTID,
( SELECT PROGRAM_ID FROM (SELECT PROGRAM_ID FROM "CMS"."CMS_R_PROGRAM" ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1 ),
( SELECT ORGANIZATION_ID FROM (SELECT ORGANIZATION_ID FROM "CMS"."CMS_ORGANIZATION" ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1 ),
( SELECT CLASS_ID FROM (SELECT CLASS_ID FROM "CMS"."CMS_R_CLASS" ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1 ),
( SELECT APPLICATION_DATA_ID FROM (SELECT APPLICATION_DATA_ID FROM "CMS"."CMS_R_APPLICATION_DATA" ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1 ),
v_GRANTNUMBER, (SELECT BEGIN_DATE FROM (SELECT BEGIN_DATE FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT ENROLLMENT_GOALS FROM (SELECT ENROLLMENT_GOALS FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT FISCAL_YEAR FROM (SELECT FISCAL_YEAR FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT FEDERAL_PROGRAM_OFFICER_EMAIL FROM (SELECT FEDERAL_PROGRAM_OFFICER_EMAIL FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT IS_CONSTRUCTION_PLUS_GRANTEE FROM (SELECT IS_CONSTRUCTION_PLUS_GRANTEE FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT MODIFIED_DATE FROM (SELECT MODIFIED_DATE FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT MODIFIED_BY FROM (SELECT MODIFIED_BY FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT CREATED_DATE FROM (SELECT CREATED_DATE FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT CREATED_BY FROM (SELECT CREATED_BY FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1),
(SELECT IS_DELETED FROM (SELECT IS_DELETED FROM CMS.CMS_GRANT ORDER BY DBMS_RANDOM.VALUE) WHERE rownum = 1)
);
END LOOP;

DBMS_RANDOM.TERMINATE;
END;
/

COMMIT;
/

143 6 / Create an account to join the discussion.
Peter Lang
Follow / 24 Mar 2018 at 3:35pm / Toad for Oracle Beta Program
Latest post by on 15 Apr 2018 at 9:43pm

13.0.0.64: Access violation at address 00000000240D32F8 in module...

Expand content
This has happened with several versions of TOAD Beta 13 when working with the editor. TOAD will freeze after this error occurred. Access violation at address 00000000240D32F8 in module 'QP5CA.dll'...

This has happened with several versions of TOAD Beta 13 when working with the editor. TOAD will freeze after this error occurred.

Access violation at address 00000000240D32F8 in module 'QP5CA.dll'. Read of address FFFFFFFF82BE92A8

There's no entry in Toad.el.
Anything else I could provide?

Best regards, Peter

Unanswered 81 6 / Create an account to join the discussion.
Peter Lang
Follow / 9 Apr 2018 at 11:14am / Toad for Oracle Beta Program
Latest post by on 9 Apr 2018 at 3:00pm

13.0.0.69: Reproducible freeze in Editor

Expand content
TOAD freezes whenever I try this: Paste the following text into an editor: ALTER TABLE x DROP COLUMN y test Position the cursor after "y". Use Shift+END to select " test". Press &q...

TOAD freezes whenever I try this:

Paste the following text into an editor:
ALTER TABLE x DROP COLUMN y        test

Position the cursor after "y".
Use Shift+END to select "        test".
Press ";"

Unanswered 48 1 / Create an account to join the discussion.
Rich J.
Follow / 5 Apr 2018 at 2:29pm / Toad for Oracle Beta Program
Latest post by on 6 Apr 2018 at 8:05pm

How to determine synonym validity in SB?

Expand content
Howdy, We had a (planned) table drop and recreate in our Prod DB last night. Today, dev calls that they can't access the table, getting: ORA-04045: errors during recompilation/revalidation of MYSCHEMA...

Howdy,

We had a (planned) table drop and recreate in our Prod DB last night.  Today, dev calls that they can't access the table, getting:

ORA-04045: errors during recompilation/revalidation of MYSCHEMA.MYSYN
ORA-16000: database open for read-only access

The dev's app is connected to our Active Data Guard physical standby that's opened read-only.  The app accesses the table via a local synonym, MYSCHEMA.MYSYN, which points to MYAPP.MYTABLE.  Going into Toad 13.0.0.69 Schema Browser, Synonyms, everything looks fine, including data retrieval.  After doing a "SELECT * FROM DBA_INVALID_OBJECTS" in the Editor, I see that the synonym is invalid, which makes sense from the app's standpoint -- the table was dropped and recreated, invalidating the synonym, but the app can't validate the synonym from its connection on the read-only standby.

But in the SB, there's no indication that the synonym is invalid.  Clicking on the RHS Data tab, the SQL pulls directly from the synonym's referenced object, instead of through the synonym.  And there's no "Valid" column in the LHS.  Because the SB's RHS Data tab SELECTs directly from the underlying object, the synonym will not validate.  That made this a bit of a head-scratcher.  Thankfully, my nails are trimmed, or I could have left gouges in my bald pate.

Any thoughts on making the validity of synonyms apparent in the SB?

Thanks!
Rich

--

Possible SQL recreation, adding a column to the underlying table (this is what our ERP does to add columns to tables):

CREATE TABLE MYAPP.MYTABLE (MYCOL1 NUMBER);

INSERT INTO MYAPP.MYTABLE (MYCOL1) VALUES (1);
COMMIT;  --yes, the DCL that follows will implicitly commit. Do it anyway!

GRANT SELECT ON MYAPP.MYTABLE TO MYSCHEMA;

CREATE SYNONYM MYSCHEMA.MYSYN FOR MYAPP.MYTABLE;

DROP TABLE MYAPP.MYTABLE PURGE;

CREATE TABLE MYAPP.MYTABLE (MYCOL1 NUMBER, MYCOL2 NVARCHAR2(32));

INSERT INTO MYAPP.MYTABLE (MYCOL1, MYCOL2) VALUES (1,N'WHEEEEEE!');
COMMIT;

GRANT SELECT ON MYAPP.MYTABLE TO MYSCHEMA;

Synonym MYSCHEMA.MYSYN is now invalid, but the SB won't show it.

Unanswered 79 3 / Create an account to join the discussion.
dwmosman
Follow / 3 Apr 2018 at 12:25am / Toad for Oracle Beta Program
Latest post by on 5 Apr 2018 at 5:31pm

Toad continues to try to logon on to Team Foundation [Beta 13.0.0...

Expand content
I have ended connection to Team Foundation. Logging on with Toad, our designated administrator schema, I disabled Team Coding on the database and set VCS Provider to "none". However, every time...

I have ended connection to Team Foundation.  Logging on with Toad, our designated administrator schema, I disabled Team Coding on the database and set VCS Provider to "none". 

However, every time I start up Toad, it comes up with the Team Foundation logon request. (this also now happens with Toad 12 so it may or may not have been caused by the beta)

Note:  I just noticed that if I start up TOAD with no session logged in, it seems to be defaulting to Team Foundation server (3rd pic).

OK.  That cleared it.  Somehow, it continued to default to Team Foundation server and tried to logon before even getting connected to any database via session logon.  Without logging on to a session, I opened team coding, selected VCS provider "none", and then clicked Apply and then OK.  Now the bare TOAD startup is not asking for logon and when I open the Team Coding window it lists "none" as the VCS provider choice. 

1. Team Configuration cleared

2. logon request keeps appearing

3. However, even with no session, this seems to be the default on Team Coding now

46 2 / Create an account to join the discussion.
imarek78
Follow / 5 Apr 2018 at 9:32am / Toad for Oracle Beta Program

Tad for Oracle Beta - 13.0.0.69 - Oracle 12.2 syntax not recogniz...

Expand content
Hello, when using Oracle 12.2. syntax for Row limiting clause, row using this syntax are marked with syntax error. Example: row #10 is marked by code editor with syntactical error: select e.id...

Hello,

when using Oracle 12.2. syntax for Row limiting clause, row using this syntax are marked with syntax error.

Example: row #10 is marked by code editor with syntactical error:

      select e.id                  employee_id
            ,e.first_name          first_name
            ,e.last_name           last_name
            ,case
              when exists (select 0
                             from org_unit u
                                 ,department_unit d
                            where u.id = d.org_unit_id
                              and d.id = e.department_unit_id
                              fetch first 1 rows only
                          ) then 'N'
              else 'Y'
             end           edit_allowed
        from employee e

Please fix this in next version.

Thank you.

Unanswered 30 0 / Create an account to join the discussion.
Dennis Paulus
Follow / 3 Apr 2018 at 6:44pm / Toad for Oracle Beta Program
Latest post by on 4 Apr 2018 at 8:14pm

Beta Released (13.0.0.69)

Expand content
Beta Notes 13.0.0.69 Internal Bug Fixes

 

Beta Notes

13.0.0.69

Internal Bug Fixes

74 2 / Create an account to join the discussion.
DougK
Follow / 3 Apr 2018 at 6:03pm / Toad for Oracle Beta Program
Latest post by on 3 Apr 2018 at 10:44pm

Should this pipelined table work in 13.0.0.66?

Expand content
SELECT * FROM TABLE (DBMS_SQLTUNE.select_workload_repository ( begin_snap => 31771, end_snap => 31777, basic_filter => 'parsing_schema_name not in (''DBSNMP'',''SYS''...

SELECT *
FROM TABLE (DBMS_SQLTUNE.select_workload_repository (
   begin_snap => 31771,
   end_snap => 31777,
   basic_filter => 'parsing_schema_name not in (''DBSNMP'',''SYS'',''ORACLE_OCM'')',
   ranking_measure1 => 'elapsed_time',
   result_limit => 250));


Access violation at address 000000000499FAA9 in module 'Toad.exe'. Read of address FFFFFFFFFFFFFFFF

This query provides results in SQLPlus and SQL Developer.

Unanswered 53 2 / Create an account to join the discussion.
droeschley_109
Follow / 2 Apr 2018 at 11:47pm / Toad for Oracle Beta Program
Latest post by on 3 Apr 2018 at 6:04pm

AV in SB

Expand content
In MDI mode, going from Editor to SB window, trying to scroll LHS. Sorry I can't be more specific about what's different this time than the same actions that succeed most other times. I generated...

In MDI mode, going from Editor to SB window, trying to scroll LHS.  Sorry I can't be more specific about what's different this time than the same actions that succeed most other times.  I generated several AVs in a row.  I've tried to attach .el file, but that didn't work (or user error), so I copied in a couple of the saved AV stacks.

Application:
-----------------------------------------------------------------------
1.1 Start Date : Sun, 1 Apr 2018 15:06:54 -0500
1.2 Name/Description: Toad.exe - (Toad® for Oracle)
1.3 Version Number : 13.0.0.66
1.4 Parameters :
1.6 Up Time : 1 day(s), 1 hour(s), 59 minute(s), 59 second(s)

Exception:
-----------------------------------------------------------------------------------------------------------------------
2.1 Date : Mon, 2 Apr 2018 17:06:53 -0500
2.2 Address : 00000000041A1165
2.3 Module Name: Toad.exe - (Toad® for Oracle)
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 00000000041A1165 in module 'Toad.exe'. Read of address 00000060FF000008.
2.7 ID : 1283130F
2.8 Count : 1
2.11 Sent : 0

User:
---------------
3.2 Name: CHX

Active Controls:
--------------------------------------------------------------------------------------------------------------------------------
4.1 Form Class : TfrmObjects
4.2 Form Text : DARDBA@DEVTOSS2 (dtoss2:ravenclaw) - Schema Browser (ONT.CHXBD_REPORT_QRY_07)
4.3 Control Class: TtdDScintilla
4.4 Control Text : CREATE PACKAGE BODY CHXBD_Report_Qry_07
IS
c_Package_Name CONSTANT VARCHAR2(30) := 'CHXBD_Report_Qry_07';
.
FUNCTION Is_Timestamp(p_String IN VARCHAR2
,p_Format IN VARCHAR2 DEFAULT c_Timestamp_Format)
RETURN INTEGER
IS
v_Timestamp TIMESTAMP;
BEGIN
v_Timestamp := TO_TIMESTAMP(p_String, p_Format);
RETURN c_True;
EXCEPTION
WHEN OTHERS THEN
RETURN c_False;
END Is_Timestamp;
.
FUNCTION Convert_GMT_Timestamp_Str(p_String IN VARCHAR2
,p_Format IN VARCHAR2 DEFAULT c_Timestamp_Format)
RETURN VARCHAR2
IS
BEGIN
RETURN TO_CHAR(FROM_TZ(TO_TIMESTAMP(p_String, p_Format), 'GMT') at TIME ZONE 'US/Central', p_Format);
EXCEPTION
WHEN OTHERS THEN
RETURN p_String;
END Convert_GMT_Timestamp_Str;
.
FUNCTION Is_Number(p_String IN VARCHAR2
,p_Format IN VARCHAR2 DEFAULT c_Number_Format)
RETURN INTEGER
IS
v_Num

Computer:
---------------------------------------------------------------------------------------------------------------------
5.2 Total Memory : 8545914880 (7.96 Gb)
5.3 Free Memory : 922247168 (879.52 Mb)
5.4 Total Disk : 500105216000 (465.76 Gb)
5.5 Free Disk : 322783199232 (300.62 Gb)
5.6 System Up Time : 1 day(s), 12 hour(s), 59 second(s)
5.7 Processor : Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz
5.8 Display Mode : \\.\DISPLAY1: 1920x1200x32 96 DPI @ -1920x0, \\.\DISPLAY2[PRIMARY]: 1920x1200x32 96 DPI @ 0x0
5.9 Display DPI : 96
5.10 Video Card : AMD Radeon HD 6350 (driver 8.850.0.0 - RAM 536870912)
5.11 Printer : Remote Desktop Easy Print (driver 6.3.9600.17728)
5.12 Virtual Machine:

Operating System:
--------------------------------------------------------
6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build # : 7601 (6.1.7601.23403)
6.4 Non-Unicode Language: English (0409)
6.5 Charset/ACP : 0/1252
6.6 Install Language : English (0409)
6.7 UI Language : English (0409)

Steps to reproduce:
------------
8.1 Text:


Call Stack Information:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Methods |Details|Stack |Address |Module |Offset |Source |Unit |Class |Procedure/Method |Line |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=13116; Parent=0; Priority=-2 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |
|Comment= |
|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03 |0000000000000000|00000000041A1165|Toad.exe |0000000000011165|System.pas |System |TObject |InheritsFrom | |
|00000040|03 |000000000042EBB8|00000000041A0FAC|Toad.exe |0000000000010FAC|System.pas |System | |_IsClass | |
|00000040|03 |000000000042EBE8|0000000008AAD81C|Toad.exe |000000000491D81C|frmObjects.pas |frmObjects |TfrmObjects |tlObjectsCustomDrawDataCell | |
|00000040|03 |000000000042EC48|0000000004D3EB2E|Toad.exe |0000000000BAEB2E|cxTL.pas |cxTL |TcxTreeListPainter |CustomDrawCell | |
|00000040|03 |000000000042ECB8|0000000004C93507|Toad.exe |0000000000B03507|cxInplaceContainer.pas|cxInplaceContainer| |DoDrawItem | |
|00000040|03 |000000000042ED18|0000000004C935DA|Toad.exe |0000000000B035DA|cxInplaceContainer.pas|cxInplaceContainer|TcxCustomControlCells |Paint | |
|00000040|03 |000000000042ED98|0000000004D315DA|Toad.exe |0000000000BA15DA|cxTL.pas |cxTL |TcxTreeListNodeViewData|Paint | |
|00000040|03 |000000000042EEA8|0000000004D3E835|Toad.exe |0000000000BAE835|cxTL.pas |cxTL |TcxTreeListPainter |DoPaint | |
|00000040|03 |000000000042EF28|0000000004C95B49|Toad.exe |0000000000B05B49|cxInplaceContainer.pas|cxInplaceContainer|TcxCustomControlPainter|Paint | |
|00000040|03 |000000000042EF88|0000000004C978A9|Toad.exe |0000000000B078A9|cxInplaceContainer.pas|cxInplaceContainer|TcxEditingControl |DoPaint | |
|00000040|03 |000000000042EFD8|000000000480B34C|Toad.exe |000000000067B34C|cxControls.pas |cxControls |TcxControl |Paint | |
|00000040|03 |000000000042F078|000000000453C266|Toad.exe |00000000003AC266|Vcl.Controls.pas |Vcl.Controls |TCustomControl |PaintWindow | |
|00000040|03 |000000000042F0C8|000000000480B472|Toad.exe |000000000067B472|cxControls.pas |cxControls |TcxControl |PaintWindow | |
|00000040|03 |000000000042F108|0000000004808F2C|Toad.exe |0000000000678F2C|cxControls.pas |cxControls |TcxControl |StandardPaintHandler | |
|00000040|03 |000000000042F258|00000000048091FD|Toad.exe |00000000006791FD|cxControls.pas |cxControls |TcxControl |WMPaint | |
|00000040|03 |000000000042F298|00000000041A121E|Toad.exe |000000000001121E|System.pas |System |TObject |Dispatch | |
|00000040|03 |000000000042F2E8|000000000452BCA3|Toad.exe |000000000039BCA3|Vcl.Controls.pas |Vcl.Controls |TControl |WndProc | |
|00000040|03 |000000000042F458|0000000004532B52|Toad.exe |00000000003A2B52|Vcl.Controls.pas |Vcl.Controls |TWinControl |WndProc | |
|00000040|03 |000000000042F528|0000000004809EE0|Toad.exe |0000000000679EE0|cxControls.pas |cxControls |TcxControl |WndProc | |
|00000040|03 |000000000042F588|0000000004C9793A|Toad.exe |0000000000B0793A|cxInplaceContainer.pas|cxInplaceContainer|TcxEditingControl |WndProc | |
|00000040|03 |000000000042F5C8|000000000452B780|Toad.exe |000000000039B780|Vcl.Controls.pas |Vcl.Controls |TControl |Perform | |
|00000040|03 |000000000042F628|00000000047FF6D6|Toad.exe |000000000066F6D6|cxControls.pas |cxControls | |dxBufferedPaintControl | |
|00000040|03 |000000000042F708|0000000004809243|Toad.exe |0000000000679243|cxControls.pas |cxControls |TcxControl |WMPaint | |
|00000040|03 |000000000042F748|00000000041A121E|Toad.exe |000000000001121E|System.pas |System |TObject |Dispatch | |
|00000040|03 |000000000042F798|000000000452BCA3|Toad.exe |000000000039BCA3|Vcl.Controls.pas |Vcl.Controls |TControl |WndProc | |
|00000040|03 |000000000042F908|0000000004532B52|Toad.exe |00000000003A2B52|Vcl.Controls.pas |Vcl.Controls |TWinControl |WndProc | |
|00000040|03 |000000000042F9D8|0000000004809EE0|Toad.exe |0000000000679EE0|cxControls.pas |cxControls |TcxControl |WndProc | |
|00000040|03 |000000000042FA38|0000000004C9793A|Toad.exe |0000000000B0793A|cxInplaceContainer.pas|cxInplaceContainer|TcxEditingControl |WndProc | |
|00000040|03 |000000000042FA78|0000000004531D9A|Toad.exe |00000000003A1D9A|Vcl.Controls.pas |Vcl.Controls |TWinControl |MainWndProc | |
|00000040|03 |000000000042FAC8|000000000432E3F4|Toad.exe |000000000019E3F4|System.Classes.pas |System.Classes | |StdWndProc | |
|00000040|03 |000000000042FB18|000000007753896E|user32.dll |000000000001896E|USER32.dll |USER32 | | (possible GetWindowDC+110) | |
|00000040|03 |000000000042FBD8|0000000077537296|user32.dll |0000000000017296|USER32.dll |USER32 | | (possible SetWindowTextW+626) | |
|00000040|03 |000000000042FC38|00000000775367E6|user32.dll |00000000000167E6|USER32.dll |USER32 | | (possible IsDialogMessageW+358)| |
|00000040|03 |000000000042FC98|000000007782B5EC|ntdll.dll |000000000006B5EC|ntdll.dll |ntdll | |KiUserCallbackDispatcher | |
|00000040|03 |000000000042FD20|0000000077536E2A|user32.dll |0000000000016E2A|USER32.dll |USER32 | | (possible BeginPaint+26) | |
|00000040|03 |000000000042FD28|0000000077536E37|user32.dll |0000000000016E37|USER32.dll |USER32 | | (possible BeginPaint+39) | |
|00000040|03 |000000000042FDA8|00000000046EA3EF|Toad.exe |000000000055A3EF|Vcl.Forms.pas |Vcl.Forms |TApplication |ProcessMessage | |
|00000040|03 |000000000042FE28|00000000046EA463|Toad.exe |000000000055A463|Vcl.Forms.pas |Vcl.Forms |TApplication |HandleMessage | |
|00000040|03 |000000000042FE98|00000000046EA8CF|Toad.exe |000000000055A8CF|Vcl.Forms.pas |Vcl.Forms |TApplication |Run | |
|00000040|03 |000000000042FED8|0000000009D6697B|Toad.exe |0000000005BD697B|Toad.pas |Toad | |Initialization | |
|00000040|03 |000000000042FF58|00000000776B5A4B|kernel32.dll|0000000000015A4B|kernel32.dll |kernel32 | |BaseThreadInitThunk | |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

EurekaLog 7.6.6.0 hotfix 6 8D15780CC9CEB34C98151D73D556A099 BD93FA931E1AD142AD8F3665D3765328 DA39A3EE5E6B4B0D3255BFEF95601890AFD80709 C5C409E95453AC4A87D2F58EBBCA11A1

Application:
---------------------------------------------------------
1.1 Start Date : Sun, 1 Apr 2018 15:06:54 -0500
1.2 Name/Description: Toad.exe - (Toad® for Oracle)
1.3 Version Number : 13.0.0.66
1.4 Parameters :
1.6 Up Time : 1 day(s), 2 hour(s), 24 second(s)

Exception:
-----------------------------------------------------------------------------------------------------------------------
2.1 Date : Mon, 2 Apr 2018 17:07:19 -0500
2.2 Address : 00000000041A1165
2.3 Module Name: Toad.exe - (Toad® for Oracle)
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 00000000041A1165 in module 'Toad.exe'. Read of address 00000060FF000008.
2.7 ID : 1283130F
2.8 Count : 1
2.11 Sent : 0

User:
---------------
3.2 Name: CHX

Active Controls:
--------------------------------------------------------------------------------------------------
4.1 Form Class : TfrmObjects
4.2 Form Text : DARDBA@DEVTOSS2 (dtoss2:ravenclaw) - Schema Browser (ONT.CHXBD_REPORT_QRY_07)
4.3 Control Class: TfrmObjects
4.4 Control Text : DARDBA@DEVTOSS2 (dtoss2:ravenclaw) - Schema Browser (ONT.CHXBD_REPORT_QRY_07)

Computer:
---------------------------------------------------------------------------------------------------------------------
5.2 Total Memory : 8545914880 (7.96 Gb)
5.3 Free Memory : 918999040 (876.43 Mb)
5.4 Total Disk : 500105216000 (465.76 Gb)
5.5 Free Disk : 322783240192 (300.62 Gb)
5.6 System Up Time : 1 day(s), 12 hour(s), 1 minute(s), 23 second(s)
5.7 Processor : Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz
5.8 Display Mode : \\.\DISPLAY1: 1920x1200x32 96 DPI @ -1920x0, \\.\DISPLAY2[PRIMARY]: 1920x1200x32 96 DPI @ 0x0
5.9 Display DPI : 96
5.10 Video Card : AMD Radeon HD 6350 (driver 8.850.0.0 - RAM 536870912)
5.11 Printer : Remote Desktop Easy Print (driver 6.3.9600.17728)
5.12 Virtual Machine:

Operating System:
--------------------------------------------------------
6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build # : 7601 (6.1.7601.23403)
6.4 Non-Unicode Language: English (0409)
6.5 Charset/ACP : 0/1252
6.6 Install Language : English (0409)
6.7 UI Language : English (0409)

Steps to reproduce:
------------
8.1 Text:


Call Stack Information:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Methods |Details|Stack |Address |Module |Offset |Source |Unit |Class |Procedure/Method |Line |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=13116; Parent=0; Priority=-2 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |
|Comment= |
|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03 |0000000000000000|00000000041A1165|Toad.exe |0000000000011165|System.pas |System |TObject |InheritsFrom | |
|00000040|03 |000000000042E318|00000000041A0FAC|Toad.exe |0000000000010FAC|System.pas |System | |_IsClass | |
|00000040|03 |000000000042E348|0000000008AAD81C|Toad.exe |000000000491D81C|frmObjects.pas |frmObjects |TfrmObjects |tlObjectsCustomDrawDataCell | |
|00000040|03 |000000000042E3A8|0000000004D3EB2E|Toad.exe |0000000000BAEB2E|cxTL.pas |cxTL |TcxTreeListPainter |CustomDrawCell | |
|00000040|03 |000000000042E418|0000000004C93507|Toad.exe |0000000000B03507|cxInplaceContainer.pas|cxInplaceContainer| |DoDrawItem | |
|00000040|03 |000000000042E478|0000000004C935DA|Toad.exe |0000000000B035DA|cxInplaceContainer.pas|cxInplaceContainer|TcxCustomControlCells |Paint | |
|00000040|03 |000000000042E4F8|0000000004D315DA|Toad.exe |0000000000BA15DA|cxTL.pas |cxTL |TcxTreeListNodeViewData |Paint | |
|00000040|03 |000000000042E608|0000000004D3E835|Toad.exe |0000000000BAE835|cxTL.pas |cxTL |TcxTreeListPainter |DoPaint | |
|00000040|03 |000000000042E688|0000000004C95B49|Toad.exe |0000000000B05B49|cxInplaceContainer.pas|cxInplaceContainer|TcxCustomControlPainter |Paint | |
|00000040|03 |000000000042E6E8|0000000004C978A9|Toad.exe |0000000000B078A9|cxInplaceContainer.pas|cxInplaceContainer|TcxEditingControl |DoPaint | |
|00000040|03 |000000000042E738|000000000480B34C|Toad.exe |000000000067B34C|cxControls.pas |cxControls |TcxControl |Paint | |
|00000040|03 |000000000042E7D8|000000000453C266|Toad.exe |00000000003AC266|Vcl.Controls.pas |Vcl.Controls |TCustomControl |PaintWindow | |
|00000040|03 |000000000042E828|000000000480B472|Toad.exe |000000000067B472|cxControls.pas |cxControls |TcxControl |PaintWindow | |
|00000040|03 |000000000042E868|0000000004808F2C|Toad.exe |0000000000678F2C|cxControls.pas |cxControls |TcxControl |StandardPaintHandler | |
|00000040|03 |000000000042E9B8|00000000048091FD|Toad.exe |00000000006791FD|cxControls.pas |cxControls |TcxControl |WMPaint | |
|00000040|03 |000000000042E9F8|00000000041A121E|Toad.exe |000000000001121E|System.pas |System |TObject |Dispatch | |
|00000040|03 |000000000042EA48|000000000452BCA3|Toad.exe |000000000039BCA3|Vcl.Controls.pas |Vcl.Controls |TControl |WndProc | |
|00000040|03 |000000000042EBB8|0000000004532B52|Toad.exe |00000000003A2B52|Vcl.Controls.pas |Vcl.Controls |TWinControl |WndProc | |
|00000040|03 |000000000042EC88|0000000004809EE0|Toad.exe |0000000000679EE0|cxControls.pas |cxControls |TcxControl |WndProc | |
|00000040|03 |000000000042ECE8|0000000004C9793A|Toad.exe |0000000000B0793A|cxInplaceContainer.pas|cxInplaceContainer|TcxEditingControl |WndProc | |
|00000040|03 |000000000042ED28|000000000452B780|Toad.exe |000000000039B780|Vcl.Controls.pas |Vcl.Controls |TControl |Perform | |
|00000040|03 |000000000042ED88|00000000047FF6D6|Toad.exe |000000000066F6D6|cxControls.pas |cxControls | |dxBufferedPaintControl | |
|00000040|03 |000000000042EE68|0000000004809243|Toad.exe |0000000000679243|cxControls.pas |cxControls |TcxControl |WMPaint | |
|00000040|03 |000000000042EEA8|00000000041A121E|Toad.exe |000000000001121E|System.pas |System |TObject |Dispatch | |
|00000040|03 |000000000042EEF8|000000000452BCA3|Toad.exe |000000000039BCA3|Vcl.Controls.pas |Vcl.Controls |TControl |WndProc | |
|00000040|03 |000000000042F068|0000000004532B52|Toad.exe |00000000003A2B52|Vcl.Controls.pas |Vcl.Controls |TWinControl |WndProc | |
|00000040|03 |000000000042F138|0000000004809EE0|Toad.exe |0000000000679EE0|cxControls.pas |cxControls |TcxControl |WndProc | |
|00000040|03 |000000000042F198|0000000004C9793A|Toad.exe |0000000000B0793A|cxInplaceContainer.pas|cxInplaceContainer|TcxEditingControl |WndProc | |
|00000040|03 |000000000042F1D8|0000000004531D9A|Toad.exe |00000000003A1D9A|Vcl.Controls.pas |Vcl.Controls |TWinControl |MainWndProc | |
|00000040|03 |000000000042F228|000000000432E3F4|Toad.exe |000000000019E3F4|System.Classes.pas |System.Classes | |StdWndProc | |
|00000040|03 |000000000042F278|000000007753896E|user32.dll |000000000001896E|USER32.dll |USER32 | | (possible GetWindowDC+110) | |
|00000040|03 |000000000042F338|0000000077537296|user32.dll |0000000000017296|USER32.dll |USER32 | | (possible SetWindowTextW+626) | |
|00000040|03 |000000000042F398|00000000775367E6|user32.dll |00000000000167E6|USER32.dll |USER32 | | (possible IsDialogMessageW+358) | |
|00000040|03 |000000000042F3F8|000000007782B5EC|ntdll.dll |000000000006B5EC|ntdll.dll |ntdll | |KiUserCallbackDispatcher | |
|00000040|03 |000000000042F480|0000000077533CAA|user32.dll |0000000000013CAA|USER32.dll |USER32 | | (possible SetWindowPos+186) | |
|00000040|03 |000000000042F488|0000000077532775|user32.dll |0000000000012775|USER32.dll |USER32 | |UpdateWindow | |
|00000040|03 |000000000042F4B8|000000000453743B|Toad.exe |00000000003A743B|Vcl.Controls.pas |Vcl.Controls |TWinControl |Update | |
|00000040|03 |000000000042F4E8|0000000004D239C0|Toad.exe |0000000000B939C0|cxTL.pas |cxTL |TcxCustomTreeList |ScrollWindow | |
|00000040|03 |000000000042F5D8|0000000004D5671A|Toad.exe |0000000000BC671A|cxTL.pas |cxTL |TcxTreeListViewInfo |ScrollVert | |
|00000040|03 |000000000042F658|0000000004D4516E|Toad.exe |0000000000BB516E|cxTL.pas |cxTL |TcxTreeListController |Scroll | |
|00000040|03 |000000000042F6A8|0000000004C980EF|Toad.exe |0000000000B080EF|cxInplaceContainer.pas|cxInplaceContainer|TcxEditingControl |Scroll | |
|00000040|03 |000000000042F6F8|00000000048063C8|Toad.exe |00000000006763C8|cxControls.pas |cxControls |TcxControlCustomScrollBars |DoScroll | |
|00000040|03 |000000000042F768|00000000047C424D|Toad.exe |000000000063424D|cxScrollBar.pas |cxScrollBar |TcxScrollBarHelper |Scroll | |
|00000040|03 |000000000042F7A8|00000000047C25F6|Toad.exe |00000000006325F6|cxScrollBar.pas |cxScrollBar |TcxScrollBarController |SetPositionValue | |
|00000040|03 |000000000042F7F8|00000000047C3492|Toad.exe |0000000000633492|cxScrollBar.pas |cxScrollBar |TcxScrollBarController |InternalScroll | |
|00000040|03 |000000000042F838|00000000047C3137|Toad.exe |0000000000633137|cxScrollBar.pas |cxScrollBar |TcxScrollBarController |DoScroll | |
|00000040|03 |000000000042F868|00000000047C2698|Toad.exe |0000000000632698|cxScrollBar.pas |cxScrollBar |TcxScrollBarController |SetThumbnailValue | |
|00000040|03 |000000000042F8A8|00000000047C2EDC|Toad.exe |0000000000632EDC|cxScrollBar.pas |cxScrollBar |TcxScrollBarController |DoMouseMove | |
|00000040|03 |000000000042F9B8|00000000047C24CB|Toad.exe |00000000006324CB|cxScrollBar.pas |cxScrollBar |TcxScrollBarController |MouseMove | |
|00000040|03 |000000000042F9F8|00000000047C3945|Toad.exe |0000000000633945|cxScrollBar.pas |cxScrollBar |TcxScrollBarHelper |MouseMove | |
|00000040|03 |000000000042FA28|0000000004805DA6|Toad.exe |0000000000675DA6|cxControls.pas |cxControls |TcxControlScrollBarsManager|ProcessMouseMove | |
|00000040|03 |000000000042FA78|00000000048057CE|Toad.exe |00000000006757CE|cxControls.pas |cxControls |TcxControlScrollBarsManager|HandleMessage | |
|00000040|03 |000000000042FAF8|0000000004809D31|Toad.exe |0000000000679D31|cxControls.pas |cxControls | |IsScrollBarsManagerMessage | |
|00000040|03 |000000000042FB28|0000000004809D9F|Toad.exe |0000000000679D9F|cxControls.pas |cxControls |TcxControl |WndProc | |
|00000040|03 |000000000042FB88|0000000004C9793A|Toad.exe |0000000000B0793A|cxInplaceContainer.pas|cxInplaceContainer|TcxEditingControl |WndProc | |
|00000040|03 |000000000042FBC8|0000000004531D9A|Toad.exe |00000000003A1D9A|Vcl.Controls.pas |Vcl.Controls |TWinControl |MainWndProc | |
|00000040|03 |000000000042FC18|000000000432E3F4|Toad.exe |000000000019E3F4|System.Classes.pas |System.Classes | |StdWndProc | |
|00000040|03 |000000000042FC68|0000000077539BB6|user32.dll |0000000000019BB6|USER32.dll |USER32 | | (possible TranslateMessageEx+662)| |
|00000040|03 |000000000042FD28|00000000775398BD|user32.dll |00000000000198BD|USER32.dll |USER32 | | (possible TranslateMessage+477) | |
|00000040|03 |000000000042FDA8|00000000046EA3EF|Toad.exe |000000000055A3EF|Vcl.Forms.pas |Vcl.Forms |TApplication |ProcessMessage | |
|00000040|03 |000000000042FE28|00000000046EA463|Toad.exe |000000000055A463|Vcl.Forms.pas |Vcl.Forms |TApplication |HandleMessage | |
|00000040|03 |000000000042FE98|00000000046EA8CF|Toad.exe |000000000055A8CF|Vcl.Forms.pas |Vcl.Forms |TApplication |Run | |
|00000040|03 |000000000042FED8|0000000009D6697B|Toad.exe |0000000005BD697B|Toad.pas |Toad | |Initialization | |
|00000040|03 |000000000042FF58|00000000776B5A4B|kernel32.dll|0000000000015A4B|kernel32.dll |kernel32 | |BaseThreadInitThunk | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

43 1 / Create an account to join the discussion.
droeschley_109
Follow / 28 Mar 2018 at 7:12pm / Toad for Oracle Beta Program
Latest post by on 2 Apr 2018 at 11:16pm

Session Browser support for Optimizer Adaptive plans

Expand content
Tree view does not appear to recognize Adaptive plans. I can use DBMS_XPLAN view (when connected to the correct instance), but are there plans to integrate adaptive plans into Tree view?

Tree view does not appear to recognize Adaptive plans.  I can use DBMS_XPLAN view (when connected to the correct instance), but are there plans to integrate adaptive plans into Tree view?

69 3 / Create an account to join the discussion.
wickliffe.larry
Follow / 9 Mar 2018 at 4:30pm / Toad for Oracle Beta Program
Latest post by on 2 Apr 2018 at 7:25pm

TOAD Beta 13.0.0.60 new Bug pop-up error message- Invalid release...

Expand content
Good Morning TOAD Team, TOAD Beta 13.0.0.60 new Bug pop-up error message. The modal pop-up message appears when I make a connection from the recent connections drop down list. Invalid release: &...

Good Morning TOAD Team,

     TOAD Beta 13.0.0.60 new Bug pop-up error message.  The modal pop-up message appears when I make a connection from the recent connections drop down list.  

Invalid release: ""

71 6 / Create an account to join the discussion.
wickliffe.larry
Follow / 19 Mar 2018 at 2:25pm / Toad for Oracle Beta Program
Latest post by on 2 Apr 2018 at 7:21pm

Data Generate Please make drop down fields larger to be able to see...

Expand content
Good Morning TOAD Team, I've been using the generate data a lot in TOAD 13.0.0.x's and noticed that I cannot see the full field name in the drop down lists asking for table names or sequence...

Good Morning TOAD Team,

       I've been using the generate data a lot in TOAD 13.0.0.x's and noticed that I cannot see the full field name in the drop down lists asking for table names or sequence names.  This is not "new"  the fields are just as small in older TOAD versions, but the latest contractor is using the Oracle long name capability  to have more descriptive names. 

     Please make drop down fields larger to be able to see what is being selected.  

Image link as paste failed: https://drive.google.com/drive/folders/0B96lIH_F_xNBUjhQMmV5TDUxNlk

76 4 / Create an account to join the discussion.
steven.kladitis_687
Follow / 1 Apr 2018 at 4:01pm / Toad for Oracle Beta Program
Latest post by on 2 Apr 2018 at 5:33pm

Passwords/connnections beta and prod

Expand content
It would be great if they used the same shared area for connections and passwords I was using beta for a while and a few pw changed. The prod release did not know and I was stuck for while. Is it possible...

It would be great if they used the same shared area for connections and passwords  I was using beta for a while and a few pw changed.  The prod release did not know and I was stuck for while.  Is it possible to have the "shared" connection/pw between them??

53 2 / Create an account to join the discussion.
phyllis.helton_1150
Follow / 29 Mar 2018 at 9:25pm / Toad for Oracle Beta Program
Latest post by on 2 Apr 2018 at 4:54pm

Pop-Up Window Positions

Expand content
I've noticed that the various pop-up windows are getting positioned so the title bar is above the top of the screen so I can't get to it.  Most have a system menu so I've been able to use Alt...
I've noticed that the various pop-up windows are getting positioned so the title bar is above the top of the screen so I can't get to it.  Most have a system menu so I've been able to use Alt+Spacebar to move them, but in Team Coding, the pop-up that allows me to add new schemas does not have a system menu, so I can't move it.

The black part in this screenshot shows the portion of the box that is above the top of my screen.

If we can get some code to prevent the dialog boxes from going above the top of the monitor, that would be very helpful.


Blessings,

Phyllis

--
Phyllis Helton
Data Magician
Security Gestapo
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office  407-515-4452
64 2 / Create an account to join the discussion.
steven.kladitis_687

external table definition

Expand content
in the latest 13 beta I no longer see the sql for external tables, when I right click and load into editor, actuall it looks like all ways do not give the external table definition. I have gone back back...

in the  latest 13 beta I no longer see the sql for external tables, when I right click and load into editor, actuall it looks like all ways do not give the external table definition.  I have gone back back to Prod toad to get this so I can get the definition.

Thanks,

Steven

27 0 / Create an account to join the discussion.
Peter Lang
Follow / 29 Mar 2018 at 10:15am / Toad for Oracle Beta Program
Latest post by on 29 Mar 2018 at 4:14pm

Rule 4207: False positive

Expand content
This rule should not be triggered by the following code, there is no good way to resequence this. BEGIN IF( NOT some_function(1) ) THEN RETURN; END IF; END;

This rule should not be triggered by the following code, there is no good way to resequence this.

BEGIN
  IF( NOT some_function(1) ) THEN
    RETURN;
  END IF;
END;

Unanswered 52 1 / Create an account to join the discussion.
Peter Lang
Follow / 29 Mar 2018 at 10:29am / Toad for Oracle Beta Program

Rule 6724: What does this mean?

Expand content
Why is "Rule 6724: Check on PL/SQL block and loop label matching." triggered here and what does it mean? CREATE PACKAGE BODY test_package AS END test_package; /

Why is "Rule 6724: Check on PL/SQL block and loop label matching." triggered here and what does it mean?

CREATE PACKAGE BODY test_package
AS
END test_package;
/

Unanswered 32 0 / Create an account to join the discussion.
Mark G
Follow / 16 Feb 2018 at 9:38am / Toad for Oracle Beta Program
Latest post by on 29 Mar 2018 at 7:58am

Recently Opened File Lists are Inconsistent

Expand content
This isn't of massive importance, it's just something I noticed that I thought I'd make you aware of.... If I go to File --> Reopen file, I get the list of recently opened files as you...

This isn't of massive importance, it's just something I noticed that I thought I'd make you aware of....

If I go to File --> Reopen file, I get the list of recently opened files as you would expect but if I use the dropdown list next to the Open File icon, the list is different. The first few are the same but then the differences start.

In the attached screenshots you can see that both lists are the same down to entry number 7 but then the entries 8 through 12 in the 1st list don't even appear in the 2nd one! Entries 20 to 23 in the 1st one have moved up to 14 to 17 in the 2nd while entry 13 in the 1st has moved down to 19 in the 2nd!

It's not the 1st time I've noticed this but another member of our team mentioned it to me today so I thought I'd raise it with you to have a look at.

Toad_File_List_Screenshots.docx

Thanks,

Mark.

334 12 / Create an account to join the discussion.
droeschley_109
Follow / 27 Mar 2018 at 6:52pm / Toad for Oracle Beta Program
Latest post by on 28 Mar 2018 at 3:49pm

Can not access a DML array as a single value

Expand content
I'm getting this in SB data grid every time I access a table with an FK. I recall this happening in a beta of some previous version but don't recall much else about it.

I'm getting this in SB data grid every time I access a table with an FK.  I recall this happening in a beta of some previous version but don't recall much else about it.

45 2 / Create an account to join the discussion.
Peter Lang
Follow / 23 Mar 2018 at 10:21am / Toad for Oracle Beta Program
Latest post by on 27 Mar 2018 at 5:19pm

Code analysis: Wrong Rule 6740 with nested table types

Expand content
This should not be a violation of the rule: BEGIN v_tab(1) := v_another_tab(1); END;

This should not be a violation of the rule:

BEGIN
  v_tab(1) := v_another_tab(1);
END;

Unanswered 46 1 / Create an account to join the discussion.