Using Oracle Store Procedure In Silverlight : Hi EH, StoredProcs in Oracle...

Fri, 08 Feb 2013 01:34:10 -700

Author: sbelini
Subject: 3958
Posted: 08-Feb-2013 at 1:34am

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;

                 ...


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

Using Oracle Store Procedure In Silverlight : I Search Forum and did not find...

Mon, 28 Jan 2013 01:23:47 -700

Author: EH
Subject: 3958
Posted: 28-Jan-2013 at 1:23am

I Search Forum and did not find any sample to use oracle SP

for example i have SP Like.

PROCEDURE Get_CLSU_CANPENKA
(
    v_SQL IN varchar2 ,
    cv_1 IN OUT SYS_REFCURSOR
)
AS
v_SQLTEMP VARCHAR2(2000) := v_SQL;

BEGIN

        OPEN cv_1    FOR SELECT * FROM CLSU_CANPENKA where rownum <3;
        --        v_SQLTEMP;

   EXCEPTION
     WHEN NO_DATA_FOUND THEN
       NULL;

END Get_CLSU_CANPENKA;

code is like ...

x.ExecuteQueryAsync(query, op =>
            {
                op.Results.ForEach(VWCLSU_CANPENKAs.Add);
                CurrentVWCLSU_CANPENKA = VWCLSU_CANPENKAs.FirstOrDefault();
                RaisePropertyChanged("CurrentVWCLSU_CANPENKA");
            });

DevForce Community Forum : Using Oracle Store Procedure In Silverlight

Using Oracle Store Procedure In Silverlight : Hi EH, StoredProcs in Oracle...

Using Oracle Store Procedure In Silverlight : I Search Forum and did not find...