Oracle Analytics and AI

Morel Cornnery

Hi All ,

Am using direct sql from OBIEE 11g to retrieve data . I've done this :

select myfunction(parameter) from dual ;

am getting the below error :

Odbc driver returned an error (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. Please have your System Administrator look at the log for more details on this error. (HY000)SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "BIB" select bib_ctl.fct_totaladjust_day(20170101) from dual ')}

asim cholas

Try this syntax.

call yourfunction(Parameters);