Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 03 Mar 2006 15:34:55 -0600
Reply-To: "Mark C. Stock" <mcstockX@Xenquery .com>
From: "Mark C. Stock" <mcstockX@Xenquery .com>
Newsgroups: comp.databases.oracle.server
References: <1141417190.487488.202620@u72g2000cwu.googlegroups.com>
Subject: Re: creating/using type dynamically
Date: Fri, 3 Mar 2006 16:34:52 -0500
Organization: Enquery, Incorporated
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2180
Message-ID: <j4mdnWzLJNIdK5XZnZ2dnUVZ_tGdnZ2d@comcast.com>
Lines: 41
NNTP-Posting-Host: 68.57.99.188
X-Trace: sv3-RHbS/r/LIfWFQdNLKI11OEsaJNY6hR8Lr4+k5twERYZwd5ECn44TIfsCpArHesW++cEmGgMct1x8Oxa!8ujbGReIVqKjIX6swHTClCizoix4YDVoERySHNauDYqNUPdfzC9lMsS0Nt2s78UOjOiSOi0JW1R0!riaXQ+gYvXztsv0=
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.32
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262742


"hitchhikar" <reachsonu@gmail.com> wrote in message 
news:1141417190.487488.202620@u72g2000cwu.googlegroups.com...
: Hi frnds,
: I am caught up in a very crazy yet obvious situation using pl/sql.
: I wil try to explain the issue here in hope of gettin some
: pointers/help
:
: I want to create a type based on the string which is my input parameter
: and then use that type.
: For eg,
:
: BEGIN
: ....
: <some code>
: ....
: EXECUTE IMMEDIATE
: 'CREATE TYPE myType AS TABLE OF '|| tblname ||'%ROWTYPE INDEX BY
: BINARY_INTEGER;';
: mytyp_var myType;
: ....
: <code>
: END;
:
:
: Now this wil create tht myType at runtime but the problem is compiling
: this piece of code as myType has nt been declared at the time of use.
: Is there a workarnd for this??where i can create and use on
: runtime...dynamically
:
: TIA
:

not standard procedure and not recommended.

if you could explain the business problem, there very likely is a solution 
that fits better with Oracle architecture and functionality.

++ mcs