Dev 2000 converting problems (ORA-00936)

From: <macdondr_at_geharris.co.uk>
Date: Thu, 01 Apr 1999 09:02:59 GMT
Message-ID: <7dvcnu$m6c$1@nnrp1.dejanews.com>

Hi all,

I'm converting a forms and reports suite from Developer/2000 1.3 (win3.1) to 2.1 (win95/NT). But one of the reports has decided not to run when called from one of the forms, but runs when executed on it's own. Here is the error thrown up by the reports background engine:

Starting report ptcs [Thu Apr 01 09:28:37 1999] ... ORA-00936: missing expression
select CREATION_DATE , PRIORITY , OZ_NAME , INCIDENT_REF , DESCRIPTION , INC_TYPE_ID , INC_CATEGORY_ID , STATUS , NUM_OFF_SUPPLY , NUM_PREDICTED , NUM_OF_CALLS , CONTROL_POSITION from INC_INCIDENT where creation_date >= NVL ( : START_TIME , ( to_dat ==>
End report ptcs [Thu Apr 01 09:28:57 1999].

Does anyone have any ideas. Thanks in advance.

                 -Dave M.



-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

Received on Thu Apr 01 1999 - 03:02:59 CST