SQL & PL/SQL

I use C# with System.Data.OracleClient.dll

I call a store procedure with OracleCommand and I want to log a full PL/SQL script about this store procedure.

for example the following code where I call a 'GetMagicNumber' store procedure:


public void InizializzaRichiesta()
{
using (OracleConnection OracleConn = new OracleConnection(_Ordini_StringConnection))
{

OracleConn.Open();
OracleCommand command = OracleConn.CreateCommand();
command.CommandType = CommandType.StoredProcedure;

command.CommandText = "GetMagicNumber";


command.Parameters.Add("Numero", OracleType.VarChar).Value = "1"
command.Parameters.Add("Value", OracleType.VarChar).Value = "2"

command.ExecuteNonQuery();
}
}


Internal I think it create the following PL/SQL text: exec GetMagicNumber("1","2")

Is there a method to get that text?


It is possible to use a spool command with C#?


thanks

Edited by: user556415 on 1-ott-2008 18.04