PLS-00357: Table,View Or Sequence reference 'string' not
allowed in this context

Answers were Sorted based on User's Feedback



PLS-00357: Table,View Or Sequence reference 'string' not allowed in this context..

Answer / ramnath

i also have the same problemm,,
Wat to need immediate answer

Is This Answer Correct ?    0 Yes 0 No

PLS-00357: Table,View Or Sequence reference 'string' not allowed in this context..

Answer / guest

Cause: A reference to database table, view, or sequence was
found in an inappropriate context. Such references can
appear only in SQL statements or (excluding sequences) in
%TYPE and %ROWTYPE declarations. Some valid examples follow:
SELECT ename, emp.deptno, dname INTO my_ename, my_deptno,
my_dept .FROM emp, dept WHERE emp.deptno = dept.deptno;
DECLARE last_name emp.ename%TYPE; dept_rec dept%ROWTYPE;

Action: Remove or relocate the illegal reference.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14404: partitioned table contains partitions in a different tablespace

1 Answers  


TNS-00039: INTCTL: error while spawning a process

1 Answers  


IMG-00841: image data allocation failed

1 Answers  


ORA-14624: DEFAULT subpartition must be last subpartition specified

1 Answers  


AMD-00157: invalid attach mode "string" specified when attempting to attach Workspace "string"

1 Answers  






NNL-00258: Server-generated requests currently do not require authoritative answers

1 Answers  


RMAN-08512: waiting for snapshot controlfile enqueue

1 Answers  


ORA-09207: sfsrd: error reading from file

1 Answers  


ORA-29869: cannot issue ALTER without REBUILD on a domain index marked FAILED

1 Answers  


ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified

2 Answers  


KUP-04089: column transform string is not the name of a table column

1 Answers  


DRG-11511: specified table does not contain a LONG RAW column

1 Answers  


Categories