OBIEE 11G -Direct SQL unable to call function in select statement

Morel Cornnery · Jan 5, 2017 3:03AM

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 · Jan 5, 2017 3:45AM

Try this syntax.

call yourfunction(Parameters);

Morel Cornnery · Jan 5, 2017 5:05AM

Hi Asim ,

thanks for the feedback . Please see on the below error am getting in trying the syntax you have proposed:

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" call bib_ctl.fct_globalrevenue_day(20170101)')}

Morel Cornnery · Jan 5, 2017 5:56AM

Hi Asim and all ,

any feedback please ? am stucked , I cannot publish the new report due to this .

If someone has suggestions or workaround , please don't hesitate to advise .

Regards ,

Morel

asim cholas · Jan 5, 2017 6:21AM

did you try a select statement from DDR window just to ensure that you have all permission to execute DDR

Morel Cornnery · Jan 5, 2017 9:25AM

Hi Asim,

you right indeed it was permission issue , now it's work fine .

Thanks for your precious advice .

Regards ,

Morel

Oracle Analytics Forum

Categories

OBIEE 11G -Direct SQL unable to call function in select statement

Answers