janusz_krzyzak
12 years agoNew Contributor
Problem with execute stored procedure
I have a stored procedure on a oracle db server, that I need to call from my tc script.
the procedure header is as follows:
create or replace procedure p_tc_przelicz_potw(ps_potw_nr varchar2) is
I have tried to implement the above in js script in two ways.
Both gave me:
Parameter object is improperly defined. Inconsistent or incomplete information was provided.
1st way which i tried:
function nFin()
{
var Proc;
Proc = ADO.CreateADOStoredProc();
Proc.ConnectionString = "Provider=MSDASQL.1;Password=xxx;Persist Security Info=True;User ID=dbm;Data Source=palt3";
Proc.ProcedureName = "p_tc_przelicz_potw";
Proc.Parameters.CreateParameter("ps_potw_nr", adVarChar, adParamInput, 12, 'HS0000002776');
Proc.ExecProc();
Log.Message("Fin realized");
}
And the 2nd way
function nFin2()
{
var Proc;
Proc = ADO.CreateADOStoredProc();
Proc.ConnectionString = "Provider=MSDASQL.1;Password=xxx;Persist Security Info=True;User ID=dbm;Data Source=palt3";
Proc.ProcedureName = "p_tc_przelicz_potw";
Proc.Parameters.AddParameter();
Proc.Parameters.AddParameter();
Proc.Parameters.Items(0).name = "ps_potw_nr";
Proc.Parameters.Items(0).DataType = adVarChar;
Proc.Parameters.Items(0).Direction = adParamInput;
Proc.Parameters.Items(0).Size = 12;
Proc.Parameters.Items(0).Value = 'HS0000002776';
Proc.ExecProc();
Log.Message("Fin realized");
}
I'm stuck at this point.. Any experts that can help?
the procedure header is as follows:
create or replace procedure p_tc_przelicz_potw(ps_potw_nr varchar2) is
I have tried to implement the above in js script in two ways.
Both gave me:
Parameter object is improperly defined. Inconsistent or incomplete information was provided.
1st way which i tried:
function nFin()
{
var Proc;
Proc = ADO.CreateADOStoredProc();
Proc.ConnectionString = "Provider=MSDASQL.1;Password=xxx;Persist Security Info=True;User ID=dbm;Data Source=palt3";
Proc.ProcedureName = "p_tc_przelicz_potw";
Proc.Parameters.CreateParameter("ps_potw_nr", adVarChar, adParamInput, 12, 'HS0000002776');
Proc.ExecProc();
Log.Message("Fin realized");
}
And the 2nd way
function nFin2()
{
var Proc;
Proc = ADO.CreateADOStoredProc();
Proc.ConnectionString = "Provider=MSDASQL.1;Password=xxx;Persist Security Info=True;User ID=dbm;Data Source=palt3";
Proc.ProcedureName = "p_tc_przelicz_potw";
Proc.Parameters.AddParameter();
Proc.Parameters.AddParameter();
Proc.Parameters.Items(0).name = "ps_potw_nr";
Proc.Parameters.Items(0).DataType = adVarChar;
Proc.Parameters.Items(0).Direction = adParamInput;
Proc.Parameters.Items(0).Size = 12;
Proc.Parameters.Items(0).Value = 'HS0000002776';
Proc.ExecProc();
Log.Message("Fin realized");
}
I'm stuck at this point.. Any experts that can help?