Operating System - HP-UX
1829378 Members
4895 Online
109991 Solutions
New Discussion

Oracle Enterprise Manager Console - SQL display

 
Stephen Keogh
Advisor

Oracle Enterprise Manager Console - SQL display

Using OEM 9.0.1.0.0 installed on remote HP-UX 11.00

If I start OEM from my local HP-UX 11.00, I get the OEM Console, I select Report Definitions, I double click on an existing report to get the Edit Report window, I click the tab Parameters to see the SQL and see something like this ...
SELECT s.username ,s.sid ...
if I highlight the line of text using the mouse I see the SQL text is really
SELECT s.username "User Name",s.sid ...
(the line of text is displayed in italics each time)
So, I don't get to see any SQL enclosed in "" or '' ( same problem when I create a new report from scratch )

If I start OEM from my local Windows NT machine using Exceed, the SQL I get to see is the expected line of text
SELECT s.username "User Name",s.sid ...
( no italics )

Back on my local HP-UX, using the CDE Style Manager I have selected the Black+White palette and restarted, with no effect on the SQL being displayed inside OEM

Any suggestions, thoughts welcome

Steve
1 REPLY 1
Stephen Keogh
Advisor

Re: Oracle Enterprise Manager Console - SQL display

The bad line from above
SELECT s.username ,s.sid ...
should read
SELECT s.username " ",s.sid ...
( without the "" )
The good line from above
SELECT s.username "User Name",s.sid ...

So, is the literal "User Name" which will be in a different colour to the rest of the SQL text not displayed due to a HP CDE colour setting restriction or problem

Any thoughts or suggestions welcome

Steve