Running Oracle 11.2.0.3.15 on Solaris.
Two test environments, each having identical spfiles (give or take database names and the like).
Here's my code in both cases:
create or replace procedure HJR_TEST
as
v_daykey_from number(10) := 13164;
v_text varchar2(3000);
begin
select cd.daykey||cd.calendardate into v_text
from cds.cdsday CD,
cds.snapshot vsp
where vsp.daykey = cd.daykey
and cd.daykey >= v_daykey_from
and rownum < 2;
dbms_output.put_line(v_text);
end;
Run that on one environment:
SQL> begin
hjr_test;
end;
PL/SQL procedure successfully completed.
1318001/FEB/16
Run it in the other environment:
Error starting at line : 18 in command -
begin
hjr_test;
end;
Error report -
ORA-01008: not all variables bound
ORA-06512: at "HJR.HJR_TEST", line 7
ORA-06512: at line 2
01008. 00000 - "not all variables bound"
*Cause:
*Action:
Same code; same init.ora settings; same version of the database; same O/S; different outcomes.
Got any clues as to where I should be looking for the trouble, please?!
Regards
HJR