Re: Numeric or value error in forms 6i
Date: Tue, 01 Apr 2003 20:31:13 GMT
Message-ID: <lGmia.32873$0g4.1159053_at_news2.east.cox.net>
"SF" <for1sam_at_yahoo.com> wrote in message
news:N_Gha.161$DD6.66474_at_news20.bellglobal.com...
> Greetings,
>
> I have a ORA-06502 Numeric or value error during my select statement in
> oracle forms 6i.
> I am selecting a text which the type is long 60000.
> the statement is as below:
>
> select text into :blk1.text from table_name ;
>
> the type of :blk1.text is also long 60000.
> the text is not null.
>
> Is there anyone that could help me with this?
>
> Thanks in advance,
>
> LM
>
>
any time you get an ORA error, first test it in the database, so you take forms out of the equation. That is a generic mis-match type error. Your variable isnt big enough to hold it, wrong type. That kind of thing.
on a hunch. Check to see if your field is big enough to hold it. 60000 is awful big for a form. Received on Tue Apr 01 2003 - 22:31:13 CEST