Refresh store proc. parameters
Next message: John Faris: "Re: TAdoQuery.Locate and TDateTime fields"
Date: Sun, 25 Apr 2004 11:55:45 -0300
I'm using D7, ADO and Oracle.
When I try to use TADOCommand.Parameters.Refresh, it always returns 0
parameters.
In design time I can select a stored procedure in Object Inspector, and I
think it means that it is possible to read Stored Procedure features.
If I assign parameters by hand and execute the stored procedure it works
well.
Does someone could imagine a reason why Refresh method is not working ?
Thank's
Next message: John Faris: "Re: TAdoQuery.Locate and TDateTime fields"
Relevant Pages
- Bind Variables ADO - Oracle
... I am trying to call a stored procedure in Oracle from my Visual Basic code. ... I am using MS ADO 2.7 library to do this. ...
(microsoft.public.vb.database.ado) - Sending CLOBs to Oracle using VB/ADO
... I have to pass some XML to an Oracle 8i stored procedure, ... without too many problems simply by setting the type of the ADO ... adParamOutput) ...
(microsoft.public.data.ado) - Sending CLOBs to Oracle using VB/ADO
... I have to pass some XML to an Oracle 8i stored procedure, ... without too many problems simply by setting the type of the ADO ... adParamOutput) ...
(microsoft.public.vb.database.ado) - RE: Call Oracle Procedure from Excel macro
... I can't answer all of your questions for Oracle, ... Set ADO "CommandText" to your stored procedure name and then set the ... In PeopleSoft I was able to build-in the prompts into the stored procedure ...
(microsoft.public.excel.programming) - Re: Error in calling stored procedure via DB link
... "Paul Clement" wrote: ... Below is an Oracle KB article that documents the issue. ... Calling Stored Procedure over Dblink Using Oracle OleDb Provider Fails ... > symptom: Using command type adCmdStoredProc ...
(microsoft.public.vb.database.ado) |
|
