Unable to execute DBMS_DATAPUMP.A DD_FILE using .NET

[sjoshi]

Hello All

I'm unable to use the ADD_FILE procedure from .NET. I can seem to get
others to work but I think I'm passing arguments incorrecty. The
message I get is:

Message: ORA-06550: line 1, column 15:
PLS-00306: wrong number or types of arguments in call to 'ADD_FILE'
ORA-06550: line 1, column 7:

These are the arguments to be passed:

/*ParameterName: HANDLE
Direction: Input
OleDbType: Decimal
ParameterName: FILENAME
Direction: Input
OleDbType: Varchar2
ParameterName: DIRECTORY
Direction: Input
OleDbType: Varchar2
ParameterName: FILESIZE
Direction: Input
OleDbType: Varchar2
ParameterName: FILETYPE
Direction: Input
OleDbType: Decimal, KU$_FILE_TYPE_D UMP_FILE CONSTANT BINARY_INTEGER
:= 1*/

//This is what I tried:
//code snippet

OracleDecimal odec = new OracleDecimal(j obHandle);
OracleDecimal odecFileType = new OracleDecimal(1 );

cmd.CommandText = "DBMS_DATAPUMP. ADD_FILE";

cmd.Parameters. Add("HANDLE", OracleDbType.De cimal,
ParameterDirect ion.Input).Valu e = odec.Value;
cmd.Parameters. Add("FILENAME", OracleDbType.Va rchar2,
ParameterDirect ion.Input).Valu e = dumpFile;
cmd.Parameters. Add("DIRECTORY" , OracleDbType.Va rchar2,
ParameterDirect ion.Input).Valu e = dumpDirObj;
cmd.Parameters. Add("FILESIZE", OracleDbType.Va rchar2,
ParameterDirect ion.Input).Valu e = string.Empty;
cmd.Parameters. Add("FILETYPE", OracleDbType.De cimal,
ParameterDirect ion.Input).Valu e = odecFileType.Va lue;

cmd.ExecuteNonQ uery(); //Fails here

Any hints are greatly appreciated.

thanks
Sunit