Conference eps::oracle

1574.0. "PLS-00201 when using system tables" by PRSSOS::MISTLER () Fri Jun 06 1997 07:55

	Hello,

	Sorry for my ignorance but I'm new to Oracle. I can create a small
procedure using my tables without any problem but when I want to use the
system tables, SQLPLUS is complaining about to declare the system tables as 
identifier
	I've try many different codes but unsuccessfully. 

	Where did I miss something ?

	Regards,

	didier

	Oracle V7.3.2 and DU V4.0


SQL> create procedure show_emp(no_emp in number)
  2   as
  3  rec_emp employees%rowtype;
  4  begin
  5  select * into rec_emp from employees  where employee_id = no_emp;
  6  dbms_output.put_line ('dddddd ' || sysdate);
  7  end;
  8  /

Procedure created.

SQL> create procedure show_tables(tab_name in char)
  2  as
  3  rec_tab_columns sys.dba_tab_columns%rowtype;
  4  begin
  5  select * into rec_tab_columns      from sys.dba_tab_columns where table_nam
e = tab_name;
  6  end;
  7  /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE SHOW_TABLES:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/17     PLS-00201: identifier 'SYS.DBA_TAB_COLUMNS' must be declared
3/17     PL/SQL: Item ignored
5/1      PL/SQL: SQL Statement ignored
5/38     PLS-00201: identifier 'SYS.DBA_TAB_COLUMNS' must be declared
SQL>