Oracle Data Provider for .NET  
Author Message
simone.naso





PostPosted: 4/3/2007 4:43:18 PM Top

dotnet-framework-aspnet, Oracle Data Provider for .NET Hello to everybody,

I hope this group is the correct one for posting my problem. If I've
posted in the wrong place, could you please redirect me to the correct
group? Thank you in advance for that ;)

My problem:

I need to call an oracle function from a .NET application passing an
XmlType input parameter to it. I have no idea on how to set the value
of this input parameter. I've tried to pass a String, but it results
in a NULL XmlType parameter value (using Toad as a SQL Profiler).

Any help is welcome,

bye,

Simone.

 
Alexey Smirnov





PostPosted: 4/3/2007 9:47:00 PM Top

dotnet-framework-aspnet >> Oracle Data Provider for .NET On Apr 3, 10:43 am, "simone.naso" <email***@***.com> wrote:
> Hello to everybody,
>
> I hope this group is the correct one for posting my problem. If I've
> posted in the wrong place, could you please redirect me to the correct
> group? Thank you in advance for that ;)
>
> My problem:
>
> I need to call an oracle function from a .NET application passing an
> XmlType input parameter to it. I have no idea on how to set the value
> of this input parameter. I've tried to pass a String, but it results
> in a NULL XmlType parameter value (using Toad as a SQL Profiler).
>
> Any help is welcome,
>
> bye,
>
> Simone.

I think this can help you

Using XML with XML DB and ODP.NET
http://www.oracle.com/technology/pub/articles/williams_xmldotnet.html

 
simone.naso





PostPosted: 4/4/2007 3:47:00 PM Top

dotnet-framework-aspnet >> Oracle Data Provider for .NET
Thank you very much Alexey,
I will look at that document and post back if that helps.

Bye,
S.

On 3 Apr, 15:47, "Alexey Smirnov" <email***@***.com> wrote:
> On Apr 3, 10:43 am, "simone.naso" <email***@***.com> wrote:
>
>
>
> > Hello to everybody,
>
> > I hope this group is the correct one for posting my problem. If I've
> > posted in the wrong place, could you please redirect me to the correct
> > group? Thank you in advance for that ;)
>
> > My problem:
>
> > I need to call an oracle function from a .NET application passing an
> > XmlType input parameter to it. I have no idea on how to set the value
> > of this input parameter. I've tried to pass a String, but it results
> > in a NULL XmlType parameter value (using Toad as a SQL Profiler).
>
> > Any help is welcome,
>
> > bye,
>
> > Simone.
>
> I think this can help you
>
> Using XML with XML DB and ODP.NEThttp://www.oracle.com/technology/pub/articles/williams_xmldotnet.html