Passing boolean parameter to an oracle procedure
-
Hi , Could you please let me know how to pass a boolean value to an oracle parameter ?. When I googled I found that boolean data type is not supported in .net With Regards
-
Hi , Could you please let me know how to pass a boolean value to an oracle parameter ?. When I googled I found that boolean data type is not supported in .net With Regards
-
Subin Mavunkal wrote:
boolean data type is not supported in .net
It most certainly is supported in .NET, http://msdn.microsoft.com/en-us/library/wts33hb3(v=VS.71).aspx[^]
which is not there in 'OracleType' structure
-
which is not there in 'OracleType' structure
-
Subin Mavunkal wrote:
'OracleType' structure
What exactly does that have to do with .NET supporting Boolean data types?
I want to pass a boolean value to an oracle parameter .My doubt is how to create .net oracle parameter for a boolean data type and pass that value. Even entity framework is not supported for stored procedures with boolean parameters
-
I want to pass a boolean value to an oracle parameter .My doubt is how to create .net oracle parameter for a boolean data type and pass that value. Even entity framework is not supported for stored procedures with boolean parameters
Subin Mavunkal wrote:
boolean value to an oracle parameter
That has nothing at all to do with .NET supporting Boolean data types. You should asking this in the database forum where database people hang out. And you might be helped by reading http://stackoverflow.com/questions/4079662/boolean-parameter-for-oracle-stored-procedure[^]
-
Subin Mavunkal wrote:
boolean value to an oracle parameter
That has nothing at all to do with .NET supporting Boolean data types. You should asking this in the database forum where database people hang out. And you might be helped by reading http://stackoverflow.com/questions/4079662/boolean-parameter-for-oracle-stored-procedure[^]
That is not the case. SPs are already written and unfortunately we can not change it :(. This is the issue The function 'SP_GBM_AUDIT_FIELD_ENTRY' has a parameter 'BCHECK' at parameter index 5 that has a data type 'pl/sql boolean' which is currently not supported for the target .NET Framework version
-
Hi , Could you please let me know how to pass a boolean value to an oracle parameter ?. When I googled I found that boolean data type is not supported in .net With Regards
Or at least most flavors don't. Usually dba's will use Char(1) Y or N to indicate boolean. I have seen quite a lot of difference. Find what ever your DB is using and pass it in: Code:
if(value== true)
parameter = "Y"
else if(value==false)
paramter = "N"
else
parameter = "FileNotFound" // : )Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost "All users always want Excel" --Ennis Lynch