Shulou(Shulou.com)06/03 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.