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 ?
|