## Working with .NET Boolean and Oracle along with ASP.NET MVC

Somethings that are straight forward in MS-SQL and .NET are bit convoluted when using Oracle and .NET. A good example for this case is when trying to map a database Boolean field to a .NET POCO. With MS-SQL we can straight away use bit which has a possible values of 1 or , but with Oracle since it does not have a built in Boolean type we would normally go with a single character field with a value of‘Y’or‘N’.

## Displaying SYS_REFCURSOR / CURSOR results from Oracle in Toad

I keep forgetting this method when I try to debug a procedure after some interval, so I am blogging it for my own reference.

Procedure:

PROCEDURE GET_ROLES_FOR_USER_LOGIN (
i_user_domain   IN     IEMS_USERS.DOMAIN%TYPE,
o_roles            OUT SYS_REFCURSOR);


Generally, we can right click on the procedure name on the schema browser and select Execute package, which gives the skeleton for executing your procedure. Once we have the code, we just add a refcursor variable at the top, assign its value from the output of the procedure and then print it at the end.