Home/ Questions/Q 4939
Next
Answered
Question
oracle user
  • 0
Explorer
Asked: 2017-04-03T21:07:53+03:00 In:

ORA-06550: line , column : PLS-00201: identifier must be declared

  • 0

I face this error when I want to execute this block of code in an anonymous pl/sql block:

DECLARE

BEGIN

SELECT last_name INTO v_last FROM employees;

dbms_output.put_line('v_last  is :' || v_last );

END;

PLS-00201: identifier must be declared

thanks.

ORAORA-06550oraclepl/sqlsql
Share

    Related Questions

    1 Answer

    1. Best Answer
      Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
      This answer was edited.

      ORA-06550: error causes are:  You tried to execute an invalid block of PLSQL code (like a stored procedure or function), but a compilation error occurred.

      in your example, you selected a value inside the variable (v_last) that is not declared in your block.

      So to correct your block of code, you can rewrite it like this:

      DECLARE
      
V_LAST EMPLOYEES.LAST_NAME%TYPE;

      BEGIN

      SELECT LAST_NAME INTO V_LAST FROM EMPLOYEES;

dbms_output.put_line(‘v_last is :’ || V_LAST );

      END;
      • 0

    Leave an answer

    You must login to add an answer.

    Need An Account,