Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: Binding "Out" Parameters to Table Types for Oracle PL/SQL Stored Procedures

by enoch (Chaplain)
on Jun 06, 2003 at 19:07 UTC ( [id://263821] : note . print w/replies, xml ) Need Help??

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;