Answer / guest

Cause: The keyword VARYING was used in a PIC N variable
declaration.

Action: Remove the keyword VARYING from the variable
declaration. If you want to declare a PIC N VARCHAR
variable, specify the precompiler option VARCHAR=YES and
declare the variable as an implicit VARCHAR group item as
illustrated by the following example: EXEC SQL BEGIN DECLARE
SECTION END-EXEC. ... 01 ENAME. 05 ENAME-LEN PIC S9(4) COMP.
05 ENAME-ARR PIC N(20). ... EXEC SQL END DECLARE SECTION
END-EXEC.

Please add more information about this Error

ORA-06712: TLI Driver: error on accept

1 Answers  

---

DGM-16901: Unable to initialize environment

1 Answers  

---

ORA-36674: (XSDPART12) Invalid dimension value starting at string.

1 Answers  

---

ORA-22923: amount of data specified in streaming LOB write is 0

1 Answers  

---

ORA-10661: Invalid option specified

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,

---

ORA-16729: Validating the value of property string hits error string.

1 Answers  

---

ORA-32808: message system link string does not exist

1 Answers  

---

PLS-00656: field 'string' not available in input argument

1 Answers  

---

TNS-00140: Interchange specified was not found in network tables

1 Answers  

---

ORA-02777: Stat failed on log directory

1 Answers  

---

RMAN-08039: channel string: starting incremental datafile backupset restore

1 Answers  

---