Urgent-Using Ref Cursors with ODP.net
Posted on 2007-07-24
i have an asp.net page and the data i want to show in the grid i want to get from oracle. i can do that my creating logic on the page. but i wanted to separate the business logic to the database which will be faster also(than simply creating query on a webpage)
the query that i have in asp side is
select serialno, time, id, xml_data from tablename where status="error" and serialno="23455".
this record returns to me 200 rows. basically stored procedure will have have 2 IN parameters in their defination and I am not able to understand the OUT parameter. ALso I read on net if i use ref cursors then i can pass the address rather.
can someone suggest me on this?