Toad World® Forums

Can not compile

Something is very strange happen in latest 2 beta builds. I can not compile, it looks like it does not compile and is too fast. I hit F9, or the green play "Execute/Compile" button and No errors in the Messages tab but there is a red ! next to the line with the error.

If the code is longer than 1 page, i can not find the error in the package since the message tab is empty.


image

i just turned on
image
no popup after compile

That notification is a Toad croak sound, not a popup.

I didn't change anything in the last 2 betas that had anything to do with the editor. Do you remember what was the last beta version you had? Does it only not compile if there is an error? You can turn on Spool SQL to be 100% sure if Toad is compiling or not.

Hi Marc,

Are you using Team Coding, and have you logged into your version control provider?

-John

No team coding in Toad, I use the command line for GIT

Here is the spool, i turned spool on, then hit f9

-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.525
Select object_name, object_type, status, owner
from SYS.ALL_OBJECTS
where owner = 'MARC_B'
and object_type = 'PROCEDURE'
and object_name = 'XXX'
order by object_name;

-- Elapsed Time: 0 seconds
-- Rows fetched: 1


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.525
Select s.*
FROM SYS.ALL_SYNONYMS s
WHERE ((s.OWNER = 'MARC_B') OR ((s.TABLE_OWNER = 'MARC_B') or (s.table_owner is null) and s.OWNER = 'PUBLIC'))
and S.TABLE_NAME = 'XXX'
and s.db_link is null
order by s.owner, s.synonym_name;

-- Elapsed Time: 0.031 seconds
-- Rows fetched: 0


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select *
from sys.user_obj_audit_opts
where (SUBSTRB (alt, 1, 1) in ('-', 'A', 'S')) and
((alt <> '-/-') or (aud <> '-/-') or (com <> '-/-') or
(del <> '-/-') or (gra <> '-/-') or (ind <> '-/-') or
(ins <> '-/-') or (loc <> '-/-') or (ren <> '-/-') or
(sel <> '-/-') or (upd <> '-/-') or
(exe <> '-/-') or (rea <> '-/-') or (wri <> '-/-') or (fbk <> '-/-'))
and object_type in ('PROCEDURE')
and OBJECT_NAME = 'XXX';

-- Elapsed Time: 0 seconds
-- Rows fetched: 0


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select
line,
name, text
from SYS.USER_SOURCE
where 1=1
and type = 'PROCEDURE'
and name in (
'XXX'
)
order by name, line;

-- Elapsed Time: 0 seconds
-- Rows fetched: 10


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select t.grantee, t.owner, t.table_name, t.grantor, t.privilege, t.grantable,
t.HIERARCHY,
o.OBJECT_TYPE, 'NO' as COMMON
from SYS.USER_TAB_PRIVS t, SYS.USER_OBJECTS o
where 1=1
and t.TABLE_NAME = o.OBJECT_NAME
and o.object_type in ('PROCEDURE')
and t.owner = 'MARC_B'
and TABLE_NAME = 'XXX'
ORDER BY 1, 2, 3, 5;

-- Elapsed Time: 0 seconds
-- Rows fetched: 0


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select object_name, object_type, status, owner
from SYS.ALL_OBJECTS
where owner = 'MARC_B'
and object_type = 'PROCEDURE'
and object_name = 'XXX'
order by object_name;

-- Elapsed Time: 0 seconds
-- Rows fetched: 1


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.556
Select s.*
FROM SYS.ALL_SYNONYMS s
WHERE ((s.OWNER = 'MARC_B') OR ((s.TABLE_OWNER = 'MARC_B') or (s.table_owner is null) and s.OWNER = 'PUBLIC'))
and S.TABLE_NAME = 'XXX'
and s.db_link is null
order by s.owner, s.synonym_name;

-- Elapsed Time: 0.031 seconds
-- Rows fetched: 0


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.588
Select *
from sys.user_obj_audit_opts
where (SUBSTRB (alt, 1, 1) in ('-', 'A', 'S')) and
((alt <> '-/-') or (aud <> '-/-') or (com <> '-/-') or
(del <> '-/-') or (gra <> '-/-') or (ind <> '-/-') or
(ins <> '-/-') or (loc <> '-/-') or (ren <> '-/-') or
(sel <> '-/-') or (upd <> '-/-') or
(exe <> '-/-') or (rea <> '-/-') or (wri <> '-/-') or (fbk <> '-/-'))
and object_type in ('PROCEDURE')
and OBJECT_NAME = 'XXX';

-- Elapsed Time: 0 seconds
-- Rows fetched: 0


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.588
Select
line,
name, text
from SYS.USER_SOURCE
where 1=1
and type = 'PROCEDURE'
and name in (
'XXX'
)
order by name, line;

-- Elapsed Time: 0 seconds
-- Rows fetched: 10


-- Session: MARC_B@MARCDB
-- Timestamp: 15:02:02.588
Select t.grantee, t.owner, t.table_name, t.grantor, t.privilege, t.grantable,
t.HIERARCHY,
o.OBJECT_TYPE, 'NO' as COMMON
from SYS.USER_TAB_PRIVS t, SYS.USER_OBJECTS o
where 1=1
and t.TABLE_NAME = o.OBJECT_NAME
and o.object_type in ('PROCEDURE')
and

Hi Marc,

If you're not using Team Coding in that database at all, go into Team Coding -> Configuration and make sure that Team Coding is not installed. The only option you should have on the left-hand side tree is "Local Settings". If "Team Settings" or "Team Projects" is visible, Team Coding is installed and perhaps simply not being used to control anything. If that's the case, and you really aren't using Team Coding on that database (check the "Team Projects" tab), you should be able to uninstall it by selecting "Remove Team Coding from database..." in the top-left tool button drop-down.

It looks like there may be a bug that was accidentally introduced when Team Coding is installed but not controlling an object and you're not logged into your version control provider (or aren't using one).

If, however, you only see "Local Settings" in the left-hand side tree in Team Coding's configuration window, then something else may be going on. If you can, check that configuration window and let us know what you find.

Thanks,

-John

Team coding was turned on and installed. I installed it a long time ago, but never used it. I just uninstalled it and now i can compile.

Did I answer your question?

Hi Marc,

Yes, that answers my question. It was that bug that was introduced, and the conditions had to align just right for it to happen. You should be good going forward, and that bug will be fixed in the next beta should you decide to try installing Team Coding again.

Thanks for letting us know about this!

-John