I have script:
Code: Select all
procedure Test(TypeName out varchar2) is
begin
select NSI_ATTRIBUTE_TYPE_NAME
into TypeName
from NSI_ATTRIBUTE_TYPES
where NSI_ATTRIBUTE_TYPE_ID = 2;
end;
Code: Select all
OraclePackage package = new OraclePackage();
package.PackageName = "PKGCONFIG";
package.Connection = myConnection;
package.Connection.Open();
OracleParameterCollection parameterCollection = package.DescribeProcedure( "Test" ); // - works
package.ExecuteProcedure( "Test", parameterCollection, true ); // exception - wrong number or types of arguments in call to 'TEST'
string myString = (string)parameterCollection["TYPENAME"].Value;
package.Connection.Close();