static void Main(string[] args)
{
using (var cn = new OracleConnection(cs))
{
//**重要** 先開啟連線,確保後續執行在同一個Session
cn.Open();
//**重要** 記得要啟用dbms_output
cn.Execute("dbms_output.enable",
commandType: CommandType.StoredProcedure);
//呼叫Stored Procedure
cn.Execute("JeffDbJobTest1",
commandType: CommandType.StoredProcedure);
//準備參數接收
DynamicParameters p = new DynamicParameters();
p.Add("line", dbType: DbType.String,
direction: ParameterDirection.Output, size: 4000);
p.Add("status", dbType: DbType.Int32,
direction: ParameterDirection.Output);
int status;
do
{
cn.Execute("dbms_output.get_line", p,
commandType: CommandType.StoredProcedure);
Console.WriteLine(p.Get<string>("line"));
status = p.Get<int>("status");
} while (status == 0);
}
}