PCC-00007: Invalid WHENEVER condition at column number in
line number of file string
Answer / guest
Cause: A condition other than SQLERROR, SQLWARNING, or NOT
FOUND was specified in an EXEC SQL WHENEVER statement, or
one of these was used, but spelled incorrectly.
Action: Correct the spelling of the WHENEVER condition or
use a host- language IF statement to test the special condition.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-21706: duration does not exist or is invalid
UDI-00011: parameter string is incompatible with parameter string
PCB-00633: Invalid host variable and attribute pairing
ORA-22991: insufficient space allocated for argument string
ORA-16094: database shutdown during archival operation
QSM-01012: SAMPLE clause present in FROM
RMAN-06551: error while looking up datafilecopy for file number: string
RMAN-06226: Automatic instance removed
NZE-29225: Certificate already installed.
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...
ORA-02715: osnpgetbrkmsg: message from host had incorrect message type
ORA-13440: GeoRaster metadata compression type error