Forum Discussion

janusz_krzyzak's avatar
janusz_krzyzak
New Contributor
12 years ago

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...
janusz_krzyzak's avatar
janusz_krzyzak
New Contributor
12 years ago
Thanks for response



I swapped in a procedure parameter varchar2 to varchar, but I still get the same message.



Now it looks like



Procedure:

create or replace procedure fin.p_tc_przelicz_potw(ps_potw_nr varchar) is



Js:

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.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");

  }



This line is higlighted

Proc.Parameters.Items(0).DataType = adVarChar;



Any suggestion ?