ORA-31430: subscriber view exists
Answer / guest
Cause: A view that is already in use was specified for the
subscriber view.
Action: Call the SUBSCRIBE procedure using a different
subscriber view name.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 0 No |
ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
ORA-21609: memory being resized without being allocated first
PLS-00210: an OTHERS clause is required in this CASE statement
ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
ORA-09758: osnipn: could not check port in name server.
QSM-01014: top level operator in WHERE clause of the query is an OR
DRG-11307: operation cannot be performed on an index
ORA-28550: pass-through SQL: cursor not found
ORA-13751: "SQL Tuning Set" "string" does not exist or user "string" is not the owner of the "SQL Tuning Set".
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...
PCC-02340: structure contains a bit field
ORA-04087: cannot change the value of ROWID reference variable