Error en procedure

[AVBorland]

Hola!
Ejecuta usted

Código SQL:

GRANT SELECT any dictionary TO system;
 

Tambien, su ha elegir significados en unas variables
por ejemplo:

Código SQL:

SQL> SHOW USER
USER IS "SYSTEM"
SQL> CREATE OR REPLACE PROCEDURE PRConsultar (nomusu  VARCHAR2)
  2  AS
  3  BEGIN
  4  SELECT user_id, account_status FROM dba_users WHERE username = nomusu;
  5  END;
  6  /
 
Warning: PROCEDURE created WITH compilation errors.
 
SQL> SHOW error
Errors FOR PROCEDURE PRCONSULTAR:
 
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1      PLS-00428: an INTO clause IS expected IN this SELECT statement
SQL>
SQL> CREATE OR REPLACE PROCEDURE PRConsultar (nomusu  VARCHAR2)
  2  AS
  3  ValueVC VarChar2(10);
  4  ValueInt INT;
  5  BEGIN
  6   SELECT user_id, account_status INTO ValueInt,ValueVC FROM dba_users WHERE username = nomusu;
  7   END;
  8  /
 
PROCEDURE created.
 
SQL> SHOW error
No errors.
SQL>