[FEATURE] missing feature on parsing PL/SQL with "DECLARE" cluase #1786

Activity

1. manticore-projects commented on May 15, 2023

   

   manticore-projects

   on May 15, 2023

   Contributor

   More actions

   Greetings.

   Those blocks exceed normal SQL Standard and can become very complex. See the example below.
   You will need to provide or sponsor an implementation to get those blocks supported. It will be some serious work.

   DECLARE
     l_message  
     VARCHAR2 (100) := 'Hello';
   BEGIN
     DECLARE
       l_message2     VARCHAR2 (100) := 
         l_message || ' World!'; 
     BEGIN
       DBMS_OUTPUT.put_line (l_message2);
     END;
   EXCEPTION
     WHEN OTHERS
     THEN
       DBMS_OUTPUT.put_line 
      (DBMS_UTILITY.format_error_stack);
   END;
2. manticore-projects

   closed this as completedin #2592on Sep 11, 2026