Re: creating/using type dynamically

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 4 Mar 2006 01:24:32 -0800
Message-ID: <1141464272.038221.297240@v46g2000cwv.googlegroups.com>

hitchhikar wrote:
> ....
> EXECUTE IMMEDIATE
> 'CREATE TYPE myType AS TABLE OF '|| tblname ||'%ROWTYPE INDEX BY
> BINARY_INTEGER;';
> mytyp_var myType;
> ....

Perhaps it is worth pointing out that

CREATE TYPE myType AS TABLE OF sometable%ROWTYPE INDEX BY BINARY_INTEGER; is not a valid SQL statement (try it). %ROWTYPE and associative arrays do not exist in SQL. Received on Sat Mar 04 2006 - 03:24:32 CST