Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

'ArrayBindSize is invalid' calling DBMS_DESCRIBE.DESCRIBE_PROCEDURE

414582Feb 10 2004 — edited Feb 10 2004
I'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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2004
Added on Feb 10 2004
1 comment
1,206 views