What does ORA-01008 mean in oracle
This article mainly shows you "what is the meaning of ORA-01008 in oracle", the content is simple and clear, hoping to help you solve your doubts, let the editor lead you to study and learn "what is the meaning of ORA-01008 in oracle" this article.
ORA-01008: not all variables have been bound to solve the problem, recently in learning functions and stored procedures, after establishing a function, the call has been shown to be wrong, but check the code did not find any problem, the problem unexpectedly lies in the space problem: there is an extra space between into: and id, so there is no choice but to show that there is an error.
ORA-01008: not all variables are bound
DECLAREjobNUMBER
Begin
Sys.dbms_job.submit (job= >: job
What= > 'docontractreports;'
Next_date= > to_date ('05-11-2010)
Interval= > 'trunc (sysdate,''HH24'') + 1max 2')
SYS.DBMS_OUTPUT.PUT_LINE ('JobNumberis:' | | to_char (job))
Commit
End
/
ORA-01008: a solution where not all variables are bound
After inquiry, it is because there is an extra colon ":", remove the colon and ok.
After correction
DECLAREjobNUMBER
Begin
Sys.dbms_job.submit (job= > job,-- Note: there is no colon here.
What= > 'docontractreports;'
Next_date= > to_date ('05-11-2010)
Interval= > 'trunc (sysdate,''HH24'') + 1max 2')
SYS.DBMS_OUTPUT.PUT_LINE ('JobNumberis:' | | to_char (job))
Commit
End
The above is all the content of this article "what is the meaning of ORA-01008 in oracle?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
