CONTINUE Statement

We are having following statements:-
1) CONTINUE
2) CONTINUE WHEN

1) CONTINUE:-

The CONTINUE statement makes to skip the Current iteration of the loop UNCONDITIONALLY and then transfers to next iteration of the current loop.

Syntax: continue;

Eg:

SQL> SET SERVEROUTPUT ON
SQL>
SQL> BEGIN
  2    FOR VENKY_IDX IN 1 .. 3 LOOP
  3      DBMS_OUTPUT.PUT_LINE(' VENKY_IDX BEFORE ' || VENKY_IDX);
  4      CONTINUE;
  5      DBMS_OUTPUT.PUT_LINE(' VENKY_IDX AFTER ' || VENKY_IDX);
  6    END LOOP VENKY_IDX;
  7    DBMS_OUTPUT.PUT_LINE('AFTER LOOP');
  8  END;
  9  /

 VENKY_IDX BEFORE 1
 VENKY_IDX BEFORE 2
 VENKY_IDX BEFORE 3
AFTER LOOP

PL/SQL procedure successfully completed
2) CONTINUE WHEN:-

Its same as  'CONTINUE' statement but here we can specify any condition to meet that criteria to skip the current iteration and transfer it to next iteration of the current loop.

Syntax: continue when;

Eg:

SQL> BEGIN
  2    FOR VENKY_IDX IN 1 .. 3 LOOP
  3      DBMS_OUTPUT.PUT_LINE(' VENKY_IDX BEFORE ' || VENKY_IDX);
  4      CONTINUE
  5       WHEN VENKY_IDX =2;
  6      DBMS_OUTPUT.PUT_LINE(' VENKY_IDX AFTER ' || VENKY_IDX);
  7    END LOOP VENKY_IDX;
  8    DBMS_OUTPUT.PUT_LINE('AFTER LOOP');
  9  END;
 10  /

 VENKY_IDX BEFORE 1
 VENKY_IDX AFTER 1
 VENKY_IDX BEFORE 2
 VENKY_IDX BEFORE 3
 VENKY_IDX AFTER 3
AFTER LOOP

PL/SQL procedure successfully completed


In above example when venky_idx becomes 2 then its skipping to execute "DBMS_OUTPUT.PUT_LINE(' VENKY_IDX AFTER ' || VENKY_IDX);" .

Basically Continue when statement will be used to skip some execution if any requirement meets or doesn't meet as above eg.


Flow of Continue statement:-

Restrictions on CONTINUE Statement:-

• A CONTINUE statement must be inside a LOOP statement.
• A CONTINUE statement cannot cross a subprogram or method boundary.
  
  
  
  

Resolved Install has encountered an error while attempting to verify your virtual memory settings. Please verify that the sum of the initial sizes of the paging files is at least 256 MB

While installing forms ,we may get following error "Install has encountered an error while attempting to verify your virtual memory settings. Please verify that the sum of the initial sizes of the paging files is at least 256 MB".

Solution: 

1    1)  Change the specified parameter -->  Computer --> Properties --> Advanced System Settings --> Advanced --> Performance Setting --> Advanced --> Change

Un check Automatically manage paging , and select Custom Size.

Custom the size as shown below and click on Set

          2) Restart the system and retry installation

Solving Abnormal program termination. An internal error has occured in Forms installation

We might face below issue while installing forms software.

 

 Solution:

Go to setup.exe and right click  then select properties and check the box as below to solve this issue.

 

 Once you retry installation issue will be resolved and will get below screen.

 

 

 

Solving operating system version: must be 5.0, 5.1, 5.2. Actual 6.1 Failed in Win - 7 (64 Bit)

You might face an issue while installing Oracle 10g forms as below.

So lets go software folder and search for "oraparam.ini" file and edit it and then
modify as below to accept 6.1 version.

Ideally this 'oraparam.ini' file will be present above your "setup.exe" file which we use for installation.

[Certified Versions]
Windows=5.0,5.1,5.2,6.1

then save and retry installation.