Oracle Stored Procedures with Enterprise Library June 2005 Version

[ssp]

Hello there,

I am trying to do very simple thing in trying to return results from an
Oracle (10g) Stored Procedure using the Enterprise Library June 2005
Version.

The stored procedure first:
=============== =============== ==============
CREATE OR REPLACE PROCEDURE AGENCYSELECTALL (p_cursor OUT
SelectPackage.S electCursor)
as
begin
open p_cursor for select * from sa.agency;
end AGENCYSELECTALL ;
/
=============== =============== ==============

The cursor is defined in a package called SelectPackage as
=============== =============== =============
CREATE OR REPLACE PACKAGE SelectPackage AS

TYPE SelectCursor IS REF CURSOR;

END SelectPackage;
/
=============== =============== ==============

The code for executing the stored procedure looks a like this:
=============== =============== ==============
public AgencyEntityCol lection SelectAll()
{
DBCommandWrappe r dbCommandWrappe r =
this.Db.GetStor edProcCommandWr apper("AGENCYSE LECTALL");

OracleParameter prms = new OracleParameter ();

prms = new OracleParameter ("P_CURSOR", OracleType.Curs or, 30000,
ParameterDirect ion.Output, Convert.ToBoole an(1), 0, 0, "",
DataRowVersion. Default, null);

dbCommandWrappe r.AddOutParamet er(prms.Paramet erName, prms.DbType,
prms.Size);
return
(AgencyEntityCo llection)this.E xecuteSPMultipl e(typeof(Agency EntityCollectio n),
typeof(AgencyEn tity), dbCommandWrappe r);
}
=============== =============== ==============

Now, everytime I run this, I get the error:
=============== =============== ==============
Message: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'AGENCYSELECTAL L'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
=============== =============== ==============

Could anyone shed some light, as to what I maybe doing wrong?

Thanks

[chanmm]

Try to stick to ANSI SQL than PL/SQL for your Oracle is safe. Make sure you
do not have 2 version of Oracle in your machine.

chanmm

"ssp" <sa****@gmail.c omwrote in message
news:11******** **************@ m7g2000cwm.goog legroups.com...

Hello there,

I am trying to do very simple thing in trying to return results from an
Oracle (10g) Stored Procedure using the Enterprise Library June 2005
Version.

The stored procedure first:
=============== =============== ==============
CREATE OR REPLACE PROCEDURE AGENCYSELECTALL (p_cursor OUT
SelectPackage.S electCursor)
as
begin
open p_cursor for select * from sa.agency;
end AGENCYSELECTALL ;
/
=============== =============== ==============

The cursor is defined in a package called SelectPackage as
=============== =============== =============
CREATE OR REPLACE PACKAGE SelectPackage AS

TYPE SelectCursor IS REF CURSOR;

END SelectPackage;
/
=============== =============== ==============

The code for executing the stored procedure looks a like this:
=============== =============== ==============
public AgencyEntityCol lection SelectAll()
{
DBCommandWrappe r dbCommandWrappe r =
this.Db.GetStor edProcCommandWr apper("AGENCYSE LECTALL");

OracleParameter prms = new OracleParameter ();

prms = new OracleParameter ("P_CURSOR", OracleType.Curs or, 30000,
ParameterDirect ion.Output, Convert.ToBoole an(1), 0, 0, "",
DataRowVersion. Default, null);

dbCommandWrappe r.AddOutParamet er(prms.Paramet erName, prms.DbType,
prms.Size);
return
(AgencyEntityCo llection)this.E xecuteSPMultipl e(typeof(Agency EntityCollectio n),
typeof(AgencyEn tity), dbCommandWrappe r);
}
=============== =============== ==============

Now, everytime I run this, I get the error:
=============== =============== ==============
Message: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'AGENCYSELECTAL L'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
=============== =============== ==============

Could anyone shed some light, as to what I maybe doing wrong?

Thanks

[ssp]

The oracle stored procedure works fine. I am still experimenting with
trying to read results into my form.

chanmm wrote:

Try to stick to ANSI SQL than PL/SQL for your Oracle is safe. Make sure you
do not have 2 version of Oracle in your machine.

chanmm

"ssp" <sa****@gmail.c omwrote in message
news:11******** **************@ m7g2000cwm.goog legroups.com...

Hello there,