Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser

Chat now with support

Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks (4308824)

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks
Beschreibung
Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks.
1. Open Session Browser
2. Don't select a session
3. Click on lower right hand side LOCKS tab
4. click locks tab between User and System
Ursache

This tab requires a session (or sessions, or a node with sessions under it) to be selected on the left/top. The error is occurring because the underlying query expects a value for SID, and since no session has been selected, the missing expression error is displayed.
Lösung

WORKAROUND
If interested in locks database wide, not restricted to a list of sessions, then click the locks tab up at the top of the Session Browser (next to the Sessions tab). Otherwise, select a particular session.
STATUS
Issue fixed in version 12.11 (User will be presented with an informational message, that a session needs to be selected)
The latest release of Toad for Oracle can be downloaded here.
Fehler-ID

TOR-1219

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks (4308824)