Privet kreek!

Zanimaius' tem je...
Vrode to, no ne rabotaet,a ya muchaius' - ne mogu poniat', chto ne tak???
Mojet ti uvidish??
PL/SQL sozdaetsia normal'no, a "myReader1 = oleDbComSP.ExecuteReader() " - failed....

src]-----[/src]
CREATE OR REPLACE PACKAGE unit_pack
AS
TYPE t_unit_cursor IS REF CURSOR;

PROCEDURE units_by_id(
p_unt_id IN number,
unit_cursor OUT t_unit_cursor
);

END unit_pack;
/

CREATE OR REPLACE PACKAGE BODY UNIT_PACK
AS PROCEDURE units_by_id
(p_unt_id IN number,
unit_cursor OUT t_unit_cursor)
IS BEGIN
OPEN unit_cursor FOR SELECT * FROM c4_unit
WHERE unt_id = p_unt_id;


END units_by_id;
END unit_pack;

/
------------------------------------- String StrConn =

"Provider=oraoledb.oracle;Password=c;User ID=c;Data Source=a;oledb.net=true;plsqlrset=true";
oConn = new System.Data.OleDb.OleDbConnection(StrConn);
oConn.Open();
oleDbComSP.Connection = oConn;

string temp = txtBoxId.Text;
int untId = int.Parse(temp);

oleDbComSP.CommandText = "{call UNIT_PACK.units_by_id(?)}";


oleDbComSP.Parameters[0].Value = untId;


OleDbDataReader myReader1 = oleDbComSP.ExecuteReader();