1 Reply Latest reply on Mar 13, 2019 1:08 PM by L. Fernigrini

    error

    hemant_k

      Hi

      I have created an ODBC connection and now able fetch data from mssql through Oracle Apex.

      Have created a parameterised report wherein calling a select list .

      LOV created is as

      below

      SELECT

      "BranchName" d,

      "BranchCode" r FROM DB00xxx20@SIL_ABC_MUCS

      order by "BranchCode"

      the query runs fine at sql commands

      however throws below error when  same is used  as a parameter

       

      ORA-04052: error occurred when looking up remote object PUBLIC.DB00xxx20@SIL_ABC_MUCS ORA-00604: error occurred at recursive SQL level 3 ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'TrackNumberAuthorizationPend'. {42S22,NativeErr = 207}[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. {42000,NativeErr = 8180} ORA-02063: preceding 2 lines from SIL_ABC_MUCS

       

      Please help

       

      ISSUE RESOLVED

      as mentioned field in error is of length more than 30 i created a view and used same  for LOV

       

      thanks

       

       

      hemu

      HI

      Found that mentioned field in error is of 33 charachter long

      so I created a view in sql server and tried using same for LOV

      now the error is as below

      Error during rendering of page item P6_BRANCHES.

      ORA-06550: line 6, column 1: PLS-00428: an INTO clause is expected in this SELECT statement