'ArrayBindSize is invalid' calling DBMS_DESCRIBE.DESCRIBE_PROCEDURE
414582Feb 10 2004 — edited Feb 10 2004I'm trying to call DBMS_DESCRIBE.DESCRIBE_PROCEDURE to get a listing of all of the parameters for a stored procedure. I'm having trouble getting the parameters created properly. Most of the params are declared as one of the following:
overload OUT NUMBER_TABLE,
argument_name OUT VARCHAR2_TABLE,
I've been using the following code (overload, for example):
m_Command.Parameters.Add("overload", OracleDbType.Double, 200, DBNull.Value, ParameterDirection.Output);
m_Command.Parameters[n].CollectionType = OracleCollectionType.PLSQLAssociativeArray;
m_Command.Parameters[n].ArrayBindSize = ???;
I've tried setting ArrayBindSize to several different values, but I always seem to get the following error message "OracleParameter.ArrayBindSize is invalid".
Thoughts?
Also, in ADO, you used to be able to call Command.Refresh, which would populate the Parameters object for you (slow as it may have been). Is there anything similar available for ODP?
Any help would be greatly appreciated.