Help for this page

Select Code to Download


  1. or download this
    :ora_types
      ORA_VARCHAR2 ORA_STRING ORA_NUMBER ORA_LONG ORA_ROWID ORA_DATE
      ORA_RAW ORA_LONGRAW ORA_CHAR ORA_CHARZ ORA_MLSLABEL ORA_NTY
      ORA_CLOB ORA_BLOB ORA_RSET
    
  2. or download this
    # Build a large XML document, bind it as a CLOB,
    # extract elements through PL/SQL and return as a CLOB
    ...
    $sth->bind_param( ':in', $in_clob, { ora_type => ORA_CLOB } );
    $sth->bind_param_inout( ':out', \$out_clob, 0, { ora_type => ORA_CLOB 
    +} );
    $sth->execute;