| I want to execute an Oracle Stored Proc from JAL. I want to pass the IN paramater as a variable (not hard-coded)
 is this possible using DatabaseExecute ? ie. Could I create a string that hold the command :
 eg Create a JAL script that has a paramater p_proc_param  Dim (l_db_proc_string, string)  set (l_db_proc_string, "begin p_my_proc(") concat (l_db_proc_string, p_proc_param, l_db_proc_string)
 concat (l_db_proc_string, "); End;", l_db_proc_string)
 DatabaseExecute(l_db_proc_string, result);
 Would this work ? 
 |