Error while displaying message in PL-SQL

Asked

Viewed 294 times

0

Code

DECLARE
BEGIN

    FOR I IN (SELECT * FROM PRODUTOS_TESTE2) LOOP
          DBMS_OUTPUT.PUT_LINE(I.codigo|| ' - ' || I.categoria || ' - ' || I.VALOR); 
    END LOOP; 
END;

Error message:

Relatório de erros -
ORA-06550: line 5, column 28:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 14:
PL/SQL: SQL Statement ignored
ORA-06550: line 6, column 32:
PLS-00364: loop index variable 'I' use is invalid
ORA-06550: line 6, column 11:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:

Table structure

inserir a descrição da imagem aqui

  • Post the structure of PRODUTOS_TESTES.

  • Table name is PRODUTOS_TESTE2 same ? And try to put before the table name the Schema name, for example: "select * from schema.products_teste2"

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.