Toad v13.0.0.80
Windows
Loading a Workspace which has packages split into spec and body corrupts package files or multiple objects. I see this as a critical issue as it has messed up several of my source files now.
- Create a new package in the editor in a single editor window.
create or replace Package P_ToadMangle is
function test return integer;
end;
/
create or replace Package body P_ToadMangle is
function test return integer is
begin
return 1;
end;
end;
/
- Save package file as P_ToadMangle.sql.
- Close package in editor.
- Reopen, when prompted say yes to wanting to split as file contains multiple objects
- Save Workspace as ToadMangle.
- Close everything, open ToadMangle workspace.
- Edit something, e.g. package body, add new function
function test2 return integer is
begin
return 2;
end;
- Save P_ToadMangle.sql.
- File is now corrupted…
create or replace Package P_ToadMangle is
function test return integer;
end;
/
create or replace Package body P_ToadMangle is
function test return integer is
begin
return 1;
end;
end;
/
create or replace Package P_ToadMangle is
function test return integer;
end;
/
create or replace Package body P_ToadMangle is
function test return integer is
begin
return 1;
end;
function test2 return integer is
begin
return 2;
end;
end;
/