Anonymous block is error

[albertTT]

Hi, all

I'm programming(as Orange for oracle) PL/SQL Tool.
(mfc(odbc), oracle 9i)
but, down code run then Anonymous block is error.

// Anonymous block //
DECLARE
row_emp emp%ROWTYPE;
BEGIN
SELECT * INTO row_emp FROM emp WHERE empno = 7369;
row_emp.deptno := 20;
end;
/////////////////////////

but, sqlplus run successfull.

my program is error .

///////error message //////
ORA-06550: line 2, column 9:
PLS-00201: identifier 'EMP' must be declared
ORA-06550: line 2, column 9:
PL/SQL: Item ignored
ORA-06550: line 4, column 28:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 4, column 1:
PL/SQL: SQL Statement ignored
ORA-06550: line 5, column 1:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 5, column 1:
PL/SQL: Statement ignored

//////////////////////////////////

How must coding?

Thanks.

 

[Marco Kalter]

This error indicates that there is no EMP table (or view) in the schema of the current user. You must either create the table in your schema, or create a private or public synonym for the EMP table, or prefix the table with the owner of the schema (e.g. scott.emp%rowtype).

 

[Stew Stryker]

Or check the GRANTs to make sure you have access to it. This one gets me ALL the time! :-(