Re: dynamic SQL question

You are so right. After taking your suggestion, my problem went away and I'm now able to process obscenely long SQL statements. Thanks a bunch.

Curtis

>
> even though you and i know YOUR table type is the same as the dbms_sql.varchar2s
> type -- the compiler doesn't believe they are.
>
> you should declare:
>
> my_tbl dbms_sql.varchar2s;
>
> don't make up your own type -- use the SAME type as dbms_sql is using.
>
> >Any help will be greatly appreciated.
> >
> >Thanks,
> >Curtis
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Sun Oct 24 1999 - 09:50:17 CEST