Execute Oracle Procedure with type Table RSS

• • Reply
  

  ferney.osori...

  0 Points

  1 Post

  Execute Oracle Procedure with type Table

  Jun 28, 2012 09:23 PM|LINK

  I have a Type "type string_array is table of varchar2(20);" is a output variable.

  i using:

  --

  OracleParameter Param3 = new OracleParameter("Datos",Oracle.DataAccess.Client.OracleDbType.Varchar2);
  Param3.Direction = ParameterDirection.Output;
  Param3.DbType = DbType.String;
  Param3.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
  Param3.Size = 4;
  Param3.Value = values;
              
  Param3.ArrayBindSize = new int[4] { 20, 20, 20, 20 };

  --

  But when i execute the procedure generate the error :

  ORA-06550: line 1, column 7:

  PLS-00306: wrong number or types of arguments in call to 'PRUEBA'

  ORA-06550: line 1, column 7:

  PL/SQL: Statement ignored

  any Idea.. Thsk

  ORA-06550: line 1, column 7:

  PLS-00306: wrong number or types of arguments in call to 'SUC_GET_VALORES'

  ORA-06550: line 1, column 7:

  PL/SQL: Statement ignored

  • Edited by ferney.osorio on Jun 28, 2012 09:23 PM
• • Reply
  

  Lannie

  Contributor

  3840 Points

  749 Posts

  Re: Execute Oracle Procedure with type Table

  Jun 29, 2012 01:09 AM|LINK

  Show the complete .NET call for Oracle

  and the PL/SQL you are calling

  then forum members can be of more help to you

   

  • Marked as answer by Young Yang - MSFT on Jul 10, 2012 02:14 PM