Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> execute immediate with User Defined Types

execute immediate with User Defined Types

From: Bullseye <none>
Date: Mon, 06 Jun 2005 13:51:02 +0100
Message-ID: <seh8a1lat18dsifhfn9hu2h0aeva5bpnms@4ax.com>


Hi

Does anyone know a work-a-round to allow User defined types to be passed To & From PL/SQL blocks using Execute Immediate? (Or Another way to do the same.)

   TYPE InfoBlock IS RECORD ( ..... );

    Status Number;
    IBlock InfoBlock;

    execute immediate 'BEGIN ' || 'UserFunc(:1,:2)' || '; END;'

                  using IN OUT Status, IN OUT IBlock;

TIA Received on Mon Jun 06 2005 - 07:51:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US