Oracle Output Parmeter

[chris]

Hi there,
I try to write out an oracle parameter from a stored procedure, but only
receive the name of the parameter. Here is what I do:

cmd.Parameters.Add(new OracleParameter("confidential",
OracleType.Number)).Direction = ParameterDirection.Output;

then i just try this:

string strPageAccess = cmd.Parameters["page_access"].Value.ToString();

which gives the error: Object reference not set to an instance of an object

Trying:
string strPageAccess = cmd.Parameters["page_access"].ToString();

Just gives out the parameter name.

What am I doing wrong? Thanks

Chris

[chris]

don't worry. I worked it out.

Thanksa guys. The code was right. I just forgot something els

"chris" wrote:

Hi there,
I try to write out an oracle parameter from a stored procedure, but only
receive the name of the parameter. Here is what I do:

cmd.Parameters.Add(new OracleParameter("confidential",
OracleType.Number)).Direction = ParameterDirection.Output;

then i just try this:

string strPageAccess = cmd.Parameters["page_access"].Value.ToString();

which gives the error: Object reference not set to an instance of an object

Trying:
string strPageAccess = cmd.Parameters["page_access"].ToString();

Just gives out the parameter name.

What am I doing wrong? Thanks

Chris