CreateADOStoredProc and a adVarChar Parameter
I am trying to call a Oracle Stored proc which returns a VarChar. But it seems to be having trouble recognising the type "adVarChar". I get the following error: "Arguments are of the ...
Forum Discussion
Hi Chris,
According to the information from this page, you should specify the adVariant constant as the data type if your stored procedure returns a VARCHAR2 value:
It seems that the adVarChar data type actually corresponds to the VARCHAR Oracle data type, not to the VARCHAR2 type. Please try using adVariant. Does this help?
How do I get it working for Oracles' VARCHAR2.
According to the information from this page, you should specify the adVariant constant as the data type if your stored procedure returns a VARCHAR2 value:
SProc.Parameters.Items(0).DataType = adVariant;
It seems that the adVarChar data type actually corresponds to the VARCHAR Oracle data type, not to the VARCHAR2 type. Please try using adVariant. Does this help?
