Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
31
Views
5
Comments
Morel Cornnery
Morel Cornnery Rank 3 - Community Apprentice
edited Aug 13, 2024 6:08PM in Oracle Analytics Cloud and Server

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 ')}

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Try this syntax.

    call yourfunction(Parameters);

  • Morel Cornnery
    Morel Cornnery Rank 3 - Community Apprentice

    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
    Morel Cornnery Rank 3 - Community Apprentice

    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
    asim cholas Rank 6 - Analytics Lead

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

  • Morel Cornnery
    Morel Cornnery Rank 3 - Community Apprentice

    Hi Asim,

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

    Thanks for your precious advice .

    Regards ,

    Morel