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 )
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%3BEN-US%3B308073
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 = strOnetFamily
cmdselect.Parameters("onetfam").Direction =
ParameterDirection.Input
since there is no OleDbType.Cursor type.
Thank you,
Burak
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
