Mapping boolean in stored procedure
Posted: Thu 04 Dec 2008 16:15
Hello,
I have 3 SP (create, update, delete) for an entity in which there's a bool property mapped on a NUMBER(1,0) table field.
in reading from db i have no problem at all, since the designer recognize correctly the mapping (in ssdl the field type is reported as bool), but with SP the ssdl type is reported as decimal, and even if i change it manually to bool (so i can compile), at runtime it doesn't work. it seems it cannot makes the conversion from the entity bool property to the NUMBER SP parameter.
in sqlserver with "bit" table field type it works.
I have 3 SP (create, update, delete) for an entity in which there's a bool property mapped on a NUMBER(1,0) table field.
in reading from db i have no problem at all, since the designer recognize correctly the mapping (in ssdl the field type is reported as bool), but with SP the ssdl type is reported as decimal, and even if i change it manually to bool (so i can compile), at runtime it doesn't work. it seems it cannot makes the conversion from the entity bool property to the NUMBER SP parameter.
in sqlserver with "bit" table field type it works.