Hi all,

I would like to query our Oracle instance for the time the instance was started.  The SQL string I use in SQL Developer is simple:  select startup_time from V$INSTANCE

I'm not able to run the same query in FM, even using native SQL.  I figure it has to do with the special character but not sure how to get it working.  Perhaps needs some macro syntax?

Thanks for the help.

------------------------------
Jeremy Aude
Channell Commercial Corporation
Rockwall TX
------------------------------

#CognosAnalyticswithWatson

Hi Jeremy,
What version of Cognos are you using?
Is there an error message shown?
I just tried it with CA 11.1.3 and it seems to work fine as a NativeSQL statement, both in FM and Data Module UI

Select startup_time from V$INSTANCE

returns:
Aug 8, 2019 2:18:10 PM

//Henk

------------------------------
HENK CAZEMIER
------------------------------

Hi Henk,

We're on 11.0.7 (working to upgrade).  It works for me as native SQL in reporting, just not in FM:  

------------------------------
Jeremy Aude
Channell Commercial Corporation
Rockwall TX
------------------------------

Original Message:
Sent: Sat August 24, 2019 08:24 PM
From: HENK CAZEMIER
Subject: Query Oracle System Object

Hi Jeremy,
What version of Cognos are you using?
Is there an error message shown?
I just tried it with CA 11.1.3 and it seems to work fine as a NativeSQL statement, both in FM and Data Module UI

Select startup_time from V$INSTANCE

returns:
Aug 8, 2019 2:18:10 PM

//Henk

------------------------------
HENK CAZEMIER
------------------------------