Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-01008: not all variables bound

Status
Not open for further replies.

jphillips

Programmer
Nov 20, 2001
24
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top