Re: varchar2s with Oracle 8i/9i

I agree. I did this for a company developing a CRM package with an XML front-end where they were passing back anonymous blocks that contained note fields (big note fields as in CLOBs). It worked but it wasn't pretty.

Daniel Morgan

Thomas Kyte wrote:

> In article <6948ef8.0203180710.2cb27d6_at_posting.google.com>,
> gmazujian_at_crosswinds.net says...
> >
> >Tom,
> > thanks for answering promptly. In answer to your query, there is
> >the possiblity that it will be > 32k. Consequently, I probably will
> >have to still use dbms_sql. However, my next question is this. Can
> >8i/9i return a ref cursor from dbms_sql? Thanks again.
> >
>
> no, it cannot. But if you are frequently (or even infrequently) executing
> dynamic (made up on the fly) blocks of code that exceed 32k in size -- I'd
> question the approach. Doesn't sound like a good idea to me.
>
> >Greg
> >
> >
> >Thomas Kyte <tkyte_at_oracle.com> wrote in message
> >news:<a72kuf0160d_at_drn.newsguy.com>...
> >> In article <6948ef8.0203152056.2b85fd30_at_posting.google.com>,
> >> gmazujian_at_crosswinds.net says...
> >> >
> >> >I am trying to migrate a Dynamic SQL stored procedure from 8.0.6 to
> >> >8i/9i. I am using the varchar2s implementation, which is a table of
> >> >rows with a 256 character width. It works fine. I would like to be
> >> >able to run this using the EXECUTE IMMEDIATE functionality, but don't
> >> >know what I am doing wrong, or if it is supported. I have 23 rows in
> >> >the table, which is in the variable v_ParseStr
> >> >
> >> >If I go to say
> >> >EXECUTE IMMEDIATE :v_ParseStr, I receive back an error saying 'BAD
> >> >BIND VARIABLE' . Does anyone know how to implement this? Thanks in
> >> >advance for any help.
> >> >
> >> >Greg
> >>
> >> not without a full example we can't.
> >>
> >> I cannot think of what you might be trying to do if v_parseStr was a table?
> >>
> >>What did the old code do (that would be useful to see) and what is the new code
> >> in full?
> >>
> >> If you are trying to parse a statement larger then 32k, you must use dbms_sql
> >> with a plsql table type.
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
Received on Mon Mar 18 2002 - 13:40:57 CST