Re: Help with query in forms4.5

From: Nuno Guerreiro <nuno-v-guerreiro_at_telecom.pt>
Date: 1998/03/18
Message-ID: <3510a273.263391697@news.telecom.pt>#1/1

On Tue, 17 Mar 1998 23:00:31 -0600, dwarakv_at_hotmail.com wrote:

>Hi,
> I am building a form using forms4.5 which takes in a date from the user
>and performs a query on two tables and dumps the results into a temporary
>table. I make sure that the date is stored/accepted correctly by printing the
>date after it is entered. I am running into problems when I making a
>comparison with the input date. I get the following error
>
> FRM-40735: When_Button_Pressed trigger raised unhandled exception
>ora-01858(non numeric found where numeric required).

Confirm that the types of the columns in the SELECT statement match the types of the columns of the table where you're inserting.

Nuno Guerreiro Received on Wed Mar 18 1998 - 00:00:00 CST