Answer / guest

Cause: The maximum number of simultaneous users of SQL*Net
IPA has been exceeded on the remote side.

Action: Wait for free connections to become available. If
the problem persists, contact your system manager.

Please add more information about this Error

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,

---

ORA-24095: invalid transformation, source type does not match that of the queue

1 Answers  

---

ORA-13826: empty SQL profile not allowed for create or update SQL profile

1 Answers  

---

DRG-10842: invalid NUMRESULTS argument supplied to FUZZY

1 Answers  

---

CLSS-00003: unable to determine cluster name. type string

1 Answers  

---

ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.

1 Answers  

---

ORA-09890: osnTXtt: malloc failed

1 Answers  

---

ORA-24812: character set conversion to or from UCS2 failed

1 Answers  

---

LPX-00225: end-element tag "~1S" does not match start-element tag "~2S"

1 Answers  

---

ORA-03247: Invalid block number specified

1 Answers  

---

O2I-00102: Unable to connect to Oracle

1 Answers  

---

ORA-00052: maximum number of enqueue resources (string) exceeded

1 Answers  

---