FRM-18103:fail to initialize the development Environment

In order for the Builder to start correctly you will need to unset the ORACLE_HOME and change the PATH so that references to the iDS environment are listed first. So, for example:

Path=C:\DevSuiteHome_1\BIN; . . . <ALL YOUR OTHER PATHS HERE> . . . ;C:\product\11.2.0\dbhome_1\BIN

Multiple Columns Array in PL/SQL

Example Only:


Declare
  Cursor Employee_Id_Cur Is
    Select empno, ename, job, sal, deptno
      From emp;
  Type Employeearraytype Is Table Of Employee_Id_Cur%Rowtype;
  Employeearray Employeearraytype;
Begin
  Open Employee_Id_Cur;
  Loop
    Fetch Employee_Id_Cur Bulk Collect
      Into Employeearray;
    Exit When Employee_Id_Cur%Notfound;
  End Loop;
  Close Employee_Id_Cur;
      For j In Employeearray.First .. Employeearray.Last Loop      
      DBMS_OUTPUT.PUT_LINE(Employeearray(j).empno);
      DBMS_OUTPUT.PUT_LINE(Employeearray(j).ename);
      DBMS_OUTPUT.PUT_LINE(Employeearray(j).job);
      DBMS_OUTPUT.PUT_LINE(Employeearray(j).sal);
      DBMS_OUTPUT.PUT_LINE(Employeearray(j).deptno);    
      End Loop;
End;
/