This a bit off topic, but i'm hoping somebody here may be able to help.

I have a view in oracle which is doing a union on a few other tables. The tables all have a column in common which is defined as NUMBER(6) in all tables. I would expect the view to have the same column type in this instance but when i get the schema info for the view at runtime it is being reported as a Decimal instead of an Int32.

This is a problem when i try to add a relationship between this view and another table on this column as it reports a type mismatch between the columns.

Anybody encountered this behaviour before? I've tried using both Oracle 8 & 9, with the same results.

Erm, does this post help at all

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=897

Yeah, well i thought it might be something like that but all the tables used in the view are defined correctly. As far as i'm aware the view just gets it's column types from the tables used, you cant actually specify them specifically

I've managed to get around the problem in code but i still dont know why there's a problem at all.

If you specify the view without the union, then check if the column type is a number(6), and then alter the view with adding the union, does that help?