public void TestSQLProc(String callback)
{
//Create objects
ConnectionHandler LoginObj = GetConnection();
OracleCommand cmd = LoginObj.GetCommand();
OracleDataAdapter da = new OracleDataAdapter();
OracleDataHandler dh = new OracleDataHandler();
cmd.CommandText = "somepackage.get_function";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("V_KEY", OracleDbType.Int32).Value = 123456;
cmd.Parameters.Add("T_CURSOR", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
Response NewResponse = new Response();
NewResponse.Success = true;
NewResponse.ResultSet = dh.Serialize(dt);
NewResponse.Message = "Test Function";
//Return results as a Json.
Context.Response.Clear();
Context.Response.ContentType = "application/json";
Context.Response.Write(JsonConvert.SerializeObject(NewResponse, Formatting.Indented));
Context.Response.End();
}
public void TestSQL(String callback)
{
ConnectionHandler LoginObj = GetConnection();
OracleCommand cmd = LoginObj.GetCommand();
cmd.CommandText = "select 'test' h from dual union select 'test2' h from dual";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
OracleDataHandler dh = new OracleDataHandler();
Response NewResponse = new Response();
NewResponse.Success = true;
NewResponse.ResultSet = dh.Serialize(dr);
NewResponse.Message = "Test";
//Return results as JSON.
Context.Response.Clear();
Context.Response.ContentType = "application/json";
Context.Response.Write(JsonConvert.SerializeObject(NewResponse, Formatting.Indented));
Context.Response.End();
}