Print Thread
Page 2 of 2 1 2
Re: Typemismatch: expected Integer found Float (Oracle 11)
#9842 05/06/08 03:40 PM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
You can force the field to a float field, regardless of database version, by using a dummy expression in your SQL. An example is posted here .


Marco Kalter
Allround Automations
Re: Typemismatch: expected Integer found Float (Oracle 11)
#9843 05/07/08 12:14 PM
Joined: Nov 2006
Posts: 23
L
Member
OP Offline
Member
L
Joined: Nov 2006
Posts: 23
Well, I need it Integer. wink

What I did now, is to create my own check constraint on adding the relevant row. But I would prefer to let it oracle do...

Re: Typemismatch: expected Integer found Float (Oracle 11)
#9844 09/15/08 04:03 PM
Joined: Nov 2006
Posts: 23
L
Member
OP Offline
Member
L
Joined: Nov 2006
Posts: 23
Well, after searching Bugs on Metalinks ... My bug is comparable to an Bug that was reported concerning Date-fields on 11.1.

The solution is to first add the field with only defining the default-value and afterwards modify this field to set it to not NULL.

Code
alter table testtable add testfield number(1) default 1;
alter table testtable modify filetype not NULL;
So it work'S as aspected and you don't need an explicit Constraint.

mfg

Page 2 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.054s Queries: 14 (0.014s) Memory: 2.5245 MB (Peak: 3.0421 MB) Data Comp: Off Server Time: 2024-05-22 01:40:18 UTC
Valid HTML 5 and Valid CSS