-
Miller Rhodes
- SnapObjects
- Tuesday, 7 January 2020 07:49 PM UTC
We have using SnapDevelop quite successfully on a project where the middle tier connects to an Oracle database.
I have a process that is run from an Oracle procedure that takes about 30 seconds to complete if run from within Toad or another SQL tool.
It has 2 input parameters and 2 output parameters. When I execute it using the code below, I get a ORA-01013 error
which usually indicates a timeout. We have our connection timeout in the connection string set to 60 secs and theis is still timing out after about 30
var procedureName = "TEST_SHIP";
var idParam = ParamValue.New<string>("I_SHO_ID", i_sho_id);
var idParam2 = ParamValue.New<string>("I_REM_NUMBER", i_dummy_p);
//ParamValue.New
// The parameter 'Name' is Output type.
var nameParam = ParamValue.New<string>("O_NOTIF_ERROR_STATUS", ParameterDirection.Output);
var nameParam2 = ParamValue.New<string>("O_NOTIF_MESSAGE", ParameterDirection.Output);
// Executes the SQL statement and gets the department by nameParam.
_dataContext.SqlExecutor.ExecuteProcedure(procedureName, idParam, idParam2, nameParam, nameParam2);
o_success_failure = nameParam.Value.ToString();
o_message = nameParam2.Value.ToString();
Has anyone else run into this? I can provide more detail if questions come in
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.