-
I just can seem to get any procedure executed that uses refcursor for returning the records selected by a stored procedure..
It give the ERROR - wrong number or type of arguments in call to this procedure.....
here is the spec of the package and the body and the code i am using in VB to call this procedure...
Create or replace package FileFormRTTP IS
TYPE cur_TP_type IS REF CURSOR;
Procedure SP_FileFormRTTP(
intCLUID IN Number,
intTUID IN Number,
intRTUID IN Number,
cur_TP IN OUT cur_TP_Type);
end;
Create or replace package body FileFormRTTP AS
Procedure SP_FileFormRTTP(
intCLUID IN Number,
intTUID IN Number,
intRTUID IN Number,
cur_TP IN OUT cur_TP_Type) IS
the query that i am running is something like
Open cur_TP FOR
SELECT Distinct a.RTTPUID, b.TP From Form_Index a, Index_TP b Where
a.TUID = intTUID And a.RTUID = intRTUID And
a.CLUID = intCLUID And a.CLUID = b.CLUID And
a.RTTPUID = b.TPUID;
------------------
vb code to call the above procedure
.............
With cmdRT
.CommandText = "FileFormRTTP.SP_FileFormRTTP"
.CommandType = adCmdStoredProc
.ActiveConnection = connCmd
Set paramCLUID = .CreateParameter("CLUID", adInteger, adParamInput)
Set paramTUID = .CreateParameter("TUID", adInteger, adParamInput)
Set paramRTUID = .CreateParameter("RTUID", adInteger, adParamInput)
paramCLUID.Value = CLUID
paramTUID.Value = TUID
paramRTUID.Value = RTUID
.Parameters.Append paramCLUID
.Parameters.Append paramTUID
.Parameters.Append paramRTUID
Set rsRT = .Execute
------------------------------------------------------------------
Please advise why am i getting the error - wrong number or type of arguments in call to procedure.
thanks very very much
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|