Hola!
Ejecuta usted
Código SQL:
Ver originalGRANT SELECT any dictionary TO system;
Tambien, su ha elegir significados en unas variables
por ejemplo:
Código SQL:
Ver originalSQL> 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>