Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be
a numeric literal



PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal..

Answer / guest

Cause: The second argument passed to an EXCEPTION_INIT
pragma was something other than a numeric literal (a
variable, for example). The second argument must be a
numeric literal in the range -9999 .. -1 (excluding -100)
for Oracle errors or in the range -20000 .. -20999 for
user-defined errors.

Action: Replace the second argument with a valid error number.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02028: fetching an exact number of rows is not supported by the server

1 Answers  


RMAN-08513: datafile copy filename=string recid=string stamp=string

1 Answers  


NNL-00277: Maximum number of times a request can be reforwarded is currently number

1 Answers  


ORA-31656: cannot use TABLESPACE_EXPR filter with transportable mode

1 Answers  


QSM-02014: GROUP BY expression other than a column

1 Answers  






IMG-00823: boundary queue pop failed

1 Answers  


ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string

1 Answers  


NNL-00401: Authoritative answer: string

1 Answers  


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

0 Answers   IBM,


RMAN-06587: one or more datafilecopies were not found

1 Answers  


NNO-00083: domain "string" server "string" has no addresses

1 Answers  


ORA-39954: DEFERRED is required for this system parameter

1 Answers  






Categories