Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail
From: "hitchhikar" <reachsonu@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: creating/using type dynamically
Date: 3 Mar 2006 12:19:50 -0800
Organization: http://groups.google.com
Lines: 29
Message-ID: <1141417190.487488.202620@u72g2000cwu.googlegroups.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 1141417195 25882 127.0.0.1 (3 Mar 2006 20:19:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 3 Mar 2006 20:19:55 +0000 (UTC)
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: u72g2000cwu.googlegroups.com; posting-host=203.101.56.198;
   posting-account=gyie0A0AAADXvQ6t7PU-uPdd4XA6p38p
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262728

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