Oracle Forms problem

From: O.K.Man <okman_at_iname.com>
Date: Thu, 21 Jan 1999 19:10:16 +0800
Message-ID: <78728i$8o4$1_at_hfc.hk.super.net>

[Quoted] Dear all,

I have table with some key values starting with the '#' sign. When I try to query these records from an Oracle Forms, in the Enter-Query mode, I eneterd '#%' on the field and then execute query, however, the Oracle Forms return the error FRM-40505. By pressing Shift-F1, the system reported the actual error is ORA-00911 (invalid character) (If I entered '#00%', the system will report error ORA-00920 (invalid relational operator)). In the dialog box invoked by pressing Shift-F1, I found that the '=' sign or the 'LIKE' keyword was gone from where clause of the SQL statement :

    The where clause are supposed to be :

        col1 LIKE '#%'
        col1 LIKE '#001%'
    but the where clause became :
        col %
        col 001%

There is no problem for other special characters such as '_at_', '$'

The problem also found in Oracle Forms 5.0.

Please suggest if there is any solution.

Best regards,

O.K.Man Received on Thu Jan 21 1999 - 12:10:16 CET