Hi EH,
StoredProcs in Oracle work similar as in SQL Server. You'll find information at
http://drc.ideablade.com/devforce-2012/bin/view/Documentation/stored-procedure-queries and
http://drc.ideablade.com/devforce-2012/bin/view/Documentation/code-sample-stored-procedure-queries-silverlight.
In your stored proc sample I noticed that you are using an OUT parameter. You'd be able to retrieve it as follows:
x.ExecuteQueryAsync(query, op =>
{
var myOutputParam = op.Parameters[1].Value;
...
|
or
query.Execute();
var myOutputParam = query.Parameters[1].Value;
|
Note that you will need to cast
op.Parameters[1].Value to the appropriate type, as
op.Parameters[1].Value alone is of type object.
It's worth mentioning that, if working with SQL Server, the first OUT parameter would be retrieved at
.Parameters[0]. (as opposed to index = 1)
sbelini