0 Replies Latest reply on May 7, 2015 12:53 PM by PaoloM

    4.1GA: Missing definitions error when executing anonymous pl/sql block

    PaoloM

      Hello,

      I found another strange behaviour in SQLDev 4.1GA that did not exist in the previous version (database version is always 11.2.0.3).

       

      Whenever I execute an anonymous pl/sql block that is accepting one or more parameters, the pl/sql code seems to be executed properly, but then I see the following error in the script output panel:

       

      Error report -

      Definities ontbreken.

      (that should mean "Missing definitions" in English)

       

      Test case

      1) open a worksheet and enter the following anonymous pl/sql block:

      BEGIN
        dbms_output.put_line(:p_string);
      END;
      /
      
      
      
      

      2) execute the block with Ctrl + Enter and pass whatever string to the parameter p_string (I used AAA);

      3) verify that the script output panel contains the following error:

      Error starting at line : 1 in command -
      BEGIN
        dbms_output.put_line(:p_string);
      END;
      Error report -
      Definities ontbreken.
      
      
      
      

      4) modify the anonymous block to remove the parameter as follows:

      BEGIN
        dbms_output.put_line('AAA');
      END;
      /
      
      
      

      5) execute the block with Ctrl + Enter and verify that the error is not raised anymore;

       

      I tried the above steps with SQLDev 4.0.3, but I could not replicate the error. Is it a spurious error that we can safely ignore??

       

      Thanks,

      Paolo