Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!lnewsoutpeer00.lnd.ops.eu.uu.net!lnewsinpeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: Bullseye <none>
Newsgroups: comp.databases.oracle.server
Subject: execute immediate with User Defined Types
Date: Mon, 06 Jun 2005 13:51:02 +0100
Message-ID: <seh8a1lat18dsifhfn9hu2h0aeva5bpnms@4ax.com>
X-Newsreader: Forte Free Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
Organization: Pipex
NNTP-Posting-Host: 81-178-34-25.dsl.pipex.com
X-Trace: 1118062323 news.dial.pipex.com 302 81.178.34.25:32378
X-Complaints-To: abuse@uk.uu.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244322

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