Help for this page

Select Code to Download


  1. or download this
    CREATE OR REPLACE PACKAGE foo AS
    
    ...
      
      FUNCTION getAllDept RETURN foo.deptCurs;
    END foo;
    
  2. or download this
    CREATE OR REPLACE PACKAGE BODY foo AS
    
    ...
              RETURN(crsr);
        END getDeptCurs;
    END foo;
    
  3. or download this
    my $dbh =DBI->connect('dbi:Oracle:host=hostname;sid=theSID',
           'user',
    ...
    
    $deptRecords->finish;
    $dbh->disconnect;