How do you call a stored procedure that returns a cursor?

  • Thread starter Thread starter Burak
  • Start date Start date
B

Burak

Hello,

I have an oracle stored procedue that returns a cursor

PROCEDURE GetNumTitleUniqueFamilies
( word in varchar, src in varchar,onetfam in varchar,
wordrows out types.word_cursor_type) as
begin
open wordrows for
select distinct substr(ONETCODE, 1, 2) from PROCESSEDWORDS
where WORD = word
and SOURCE = src
and ( TITLEMAXOCCURENCE is not null and TITLEMAXOCCURENCE
0 )
Click to expand...
and substr(ONETCODE,1,2) != onetfam;
end GetNumTitleUniqueFamilies;

I found a page that shows how to call a stored procedure that returns
a cursor

http://support.microsoft.com/default.aspx?scid=kb;EN-US;308073

but I was wondering how I would add an output parameter if I want to
call it in the following manner

strSelect = "GetNumTitleUniqueFamilies"
cmdselect = New OleDbCommand(strSelect, objConnSkills2)
cmdselect.CommandType = CommandType.StoredProcedure
cmdselect.Parameters.Add("word", OleDbType.VarChar).Value =
strWord
cmdselect.Parameters("word").Direction =
ParameterDirection.Input
cmdselect.Parameters.Add("src", OleDbType.VarChar).Value =
strSource
cmdselect.Parameters("src").Direction =
ParameterDirection.Input
cmdselect.Parameters.Add("onetfam", OleDbType.VarChar).Value =
strOFam
cmdselect.Parameters("onetfam").Direction =
ParameterDirection.Input

since there is no OleDbType.Cursor type.

Thank you,

Burak
 
Yes, I had looked at a similar page that shows how to do it using
oracleconnection. I would like to find out how to do the same thing
using Oledb.

Burak
 
Back
Top