how to use Oracle package in C#?

  • Thread starter Thread starter matrix
  • Start date Start date
M

matrix

i don't know the recordcounts from Oracle package,so i can't set "resultset"
size.this is very urgent. please Advise

OleDbCommand cmdPerson = new OleDbCommand("{call
PackPerson_JamesTest.allPerson_JamesTest({resultset 4, ssn, fname,
lname})}", cnOra);
 
Hi,

Do you need to know how many records returned into datatable? Then check
Rows.Count property of the datatable
 
¤ i don't know the recordcounts from Oracle package,so i can't set "resultset"
¤ size.this is very urgent. please Advise
¤
¤ OleDbCommand cmdPerson = new OleDbCommand("{call
¤ PackPerson_JamesTest.allPerson_JamesTest({resultset 4, ssn, fname,
¤ lname})}", cnOra);
¤

Why do you need to set the size of the Resultset? If you need to limit the number of rows returned,
this should be done in the stored procedure.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top