DRG-50855: logoff fail
Answer / guest
Cause: Fail to logoff from the database
Action: check versions of code
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-02050: transaction string rolled back, some remote DBs may be in-doubt
ORA-01596: cannot specify system in string parameter
ORA-12494: cannot insert or delete a level, category, or release category
RMAN-08588: converted datafile=string
NZE-29195: CRL is expired
ORA-12402: invalid format string: string
ORA-13708: Some snapshots in the range [string, string] were purged before the analysis was complete.
NCR-01003: NCRS: Read error.
PCC-02319: expression type does not match usage
ORA-13801: invalid value for SQLTUNE_CATEGORY parameter
ORA-08205: ora_addr: $ORACLE_SID not set in environment
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...