Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!panix!newsfeed-00.mathworks.com!newscon06.news.prodigy.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!t39g2000cwt.googlegroups.com!not-for-mail From: "hitchhikar" Newsgroups: comp.databases.oracle.misc Subject: Re: create/using type dynamically Date: 3 Mar 2006 12:46:19 -0800 Organization: http://groups.google.com Lines: 12 Message-ID: <1141418779.293361.261830@t39g2000cwt.googlegroups.com> References: <1141417234.983818.20650@z34g2000cwc.googlegroups.com> <1141418189.459918@jetspin.drizzle.com> NNTP-Posting-Host: 203.101.56.198 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1141418784 9400 127.0.0.1 (3 Mar 2006 20:46:24 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 3 Mar 2006 20:46:24 +0000 (UTC) In-Reply-To: <1141418189.459918@jetspin.drizzle.com> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: t39g2000cwt.googlegroups.com; posting-host=203.101.56.198; posting-account=gyie0A0AAADXvQ6t7PU-uPdd4XA6p38p Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:125681 Ok Morgan..the busines case is like i hav gt 100 key. Each key has one or more value. Each key is associated with its own table. Now i am looping thru the keys in a proc .Now for a key, based on the keytablename ,i want to create a type and then iteriatin thru all the values of that key want to use dynamic SQL and FORALL to update that table ..and thn go on fr scnd key n so on. I dun want to hardcode the types as tomoro i can add more keys OR rename a key's table name, which means ill hav to update my sql code also (the proc is gettin an XML which contains all info of the keys). So i think u get the idea now