ORA-01008: not all variables bound

    You are trying to execute a statement which includes bind variables, but you do not provide all the needed values.


    eg:


    SQL> begin
      2    execute immediate 'select * from emp where empno=:empid';
      3  end;
      4  /
    begin
    *
    ERROR at line 1:
    ORA-01008: not all variables bound
    ORA-06512: at line 2


    SQL> begin
      2    execute immediate 'select * from emp where empno=:empid' using 1;
      3  end;
      4  /

    PL/SQL procedure successfully completed.




Adverteren bij Daisycon
Forum Messages
18-APR-2008 21:30:31ORA-01008: not all variables boundayvaz Reply
DECLARE
jobno Number := 1;

BEGIN
dbms_job.submit(
:jobno,
'BEGIN Pack.main_pro; END;',
sysdate,
'sysdate+1/24*60'
);
END;

I take 'ORA-01008: not all variables bound' error. What can I do?
: ->  19-APR-2008 21:30:13REmove the colonDbMotive Reply
You do not need the colon in front of the job id:


18-APR-2008 21:30:31 ORA-01008: not all variables bound ayvaz Reply
DECLARE
jobno Number := 1;

BEGIN
dbms_job.submit(
jobno,
'BEGIN Pack.main_pro; END;',
sysdate,
'sysdate+1/24*60'
);
END;


Add your message for ORA-01008
Name:email:
Validation Code:g3azrr3aq0ba4deui
Enter Code above:
Title:
State your problem: