Calling Oracle OCI from C#

[Kevin]

Hi All
I would like to call the following:

OCIAttrGet(ParamHandle,
OCI_DTYPE_PARAM,
HasDefault,
Nil,
OCI_ATTR_HAS_DEFAULT,
ErrorHandle);

from C#. Does anyone have any examples of how you go about calling
OCI? I am trying to find out if a stored procedure has a default
value, and there is now way to do this using any of the ADO drivers
for .NET.

Thanks in advance
Kevin

[Nicholas Paldino [.NET/C# MVP]]

Kevin,

You could easily call this through the P/Invoke layer. You left out the
return type of the call to OCIAttrGet. If you know what the types are for
the parameters as well, then you should easily be able to create a
declaration to call through P/Invoke.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Kevin" <ke**********@lycos.co.ukwrote in message
news:11**********************@o61g2000hsh.googlegr oups.com...

Hi All
I would like to call the following:

OCIAttrGet(ParamHandle,
OCI_DTYPE_PARAM,
HasDefault,
Nil,
OCI_ATTR_HAS_DEFAULT,
ErrorHandle);

from C#. Does anyone have any examples of how you go about calling
OCI? I am trying to find out if a stored procedure has a default
value, and there is now way to do this using any of the ADO drivers
for .NET.

Thanks in advance
Kevin

[Kevin]

On 25 Jul, 17:50, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail]:

Kevin,

You could easily call this through the P/Invoke layer. You left out the
return type of the call to OCIAttrGet. If you know what the types are for
the parameters as well, then you should easily be able to create a
declaration to call through P/Invoke.

--
- Nicholas Paldino [.NET/C# MVP]
- [e-mail]

"Kevin" <[e-mail] in message

news:11**********************@o61g2000hsh.googlegr oups.com...

Hi All
I would like to call the following:

OCIAttrGet(ParamHandle,
OCI_DTYPE_PARAM,
HasDefault,
Nil,
OCI_ATTR_HAS_DEFAULT,
ErrorHandle);

from C#. Does anyone have any examples of how you go about calling
OCI? I am trying to find out if a stored procedure has a default
value, and there is now way to do this using any of the ADO drivers
for .NET.

Thanks in advance
Kevin- Hide quoted text -

- Show quoted text -

Thanks Nicholas, I will check it out.