APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error with Interactive Report Query

unficypFeb 17 2012 — edited Feb 17 2012

Hi,

using apex 4.1 on 11.2.0.1

i have the following query in an IR:

select	* 
from	v_dialer_egn
where dtstart between :P200_STARTDATE and  :P200_ENDDATE

when i submit the query,the following error returns:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [FreeTDS][SQL Server]Operand type clash: text is incompatible with datetime[FreeTDS][SQL Server]Statement(s) could not be prepared. ORA-02063: preceding 2 lines from DIVOSECC

v_dialer_egn is defined as:

CREATE OR REPLACE FORCE VIEW V_DIALER_EGN
(
   DTSTART,
   AGENTNUMBER,
   AGENTNAME,
   STRCALLEDNUMBER,
   CAMPAIGNNAME,
   CALLSTATUS,
   NDURATIONSEC,
   NSPEAKDURSEC,
   NEXTRAWORKDURATIONSEC,
   CALLTRIES
)
AS
   SELECT "dtstart" AS dtstart,
          "agentnumber" AS agentnumber,
          "agentname" AS agentname,
          "strcallednumber" AS strcallednumber,
          "campaignname" AS campaignname,
          "callstatus" AS callstatus,
          "ndurationsec" AS ndurationsec,
          "nspeakdursec" AS nspeakdursec,
          "nextraworkdurationsec" AS nextraworkdurationsec,
          "calltries" AS calltries
     FROM v_ora_dialer_egn@divosecc;

the query works on sqlplus/toad/sqldeveloper

desc v_dialer_egn shows that dtstart is a date column.

if i remove the where clause, the query is accepted by apex.

v_ora_dialer_egn@divosecc is a view on mssql (v 10.x)
connected using freetds and unixodbc

Edited by: unficyp on 17.02.2012 06:31