Bind variable "JOBNO" not declared. ( Please give me solution )
I m trying to run this code in SQL plus but every time it show me
Bind variable "JOBNO" not declared. What should i do. Is it something i m missing in this code. Please give me solution. I have copy paste this code from one sode to run Job ( Schedule) In Oracle.
variable jobno number
variable instno number
SELECT instance_number INTO :instno FROM v$instance;
DBMS_JOB.SUBMIT(:jobno, 'pms.USP_HRMSMIGRATION;', trunc(sysdate)-1/1440, 'trunc(sysdate)-2/1440', TRUE, :instno);