I create a basic view.
I then create a stored procedure that takes a input varible and calls the view;
create procedure schema.SP_NAME (V_value varchar2)
var_a varchar2(30);
var_b varchar2(30);
as
cursor CUR_RATE is
SELECT field_a, field_B, FROM view_name WHERE field_A = V_value;
begin
for norml_rec in CUR_RATE loop
var_a:= norml_rec.field_a;
var_b := norml_rec.field_b;
htp.p('var_a');
htp.p('var_b');
end loop;
When I call the procedure through a web page it gives me the error
ORA-01008: not all variables bound
When I hard code the v_value with a literal it works...
Anyone run across this before???
Thanks
JP
I then create a stored procedure that takes a input varible and calls the view;
create procedure schema.SP_NAME (V_value varchar2)
var_a varchar2(30);
var_b varchar2(30);
as
cursor CUR_RATE is
SELECT field_a, field_B, FROM view_name WHERE field_A = V_value;
begin
for norml_rec in CUR_RATE loop
var_a:= norml_rec.field_a;
var_b := norml_rec.field_b;
htp.p('var_a');
htp.p('var_b');
end loop;
When I call the procedure through a web page it gives me the error
ORA-01008: not all variables bound
When I hard code the v_value with a literal it works...
Anyone run across this before???
Thanks
JP