hi, all
I have a problem as describe on topic. please see my codes below ...
with this code. it was executed successfully.Code:Dim CPw As New rdoQuery Set CPw.ActiveConnection = Cn QSQL = "{ CALL TEST(?) }" Set CPw = Cn.CreateQuery("", QSQL) CPw(0).Direction = rdParamOutput Set Rs = CPw.OpenResultset Prompt = "Return value from stored procedure is " & CPw(0) & "." Response = MsgBox(Prompt, , "Stored Procedure Result")
but this code error : couldn't find item indicated by text. Following is my Package's procedure code ...Code:Dim CPw As New rdoQuery Set CPw.ActiveConnection = Cn QSQL = "{ CALL REFTEST.GETMYVAR(?) }" Set CPw = Cn.CreateQuery("", QSQL) CPw(0).Direction = rdParamOutput <<<< ERROR Set Rs = CPw.OpenResultset Prompt = "Return value from stored procedure is " & CPw(0) & "." Response = MsgBox(Prompt, , "Stored Procedure Result")
Please help ...Code:create or replace package body reftest as Procedure GetMyVar(theValue IN OUT NUMBER) Is Begin theValue := 10; End; end;![]()




Reply With Quote
