Re: varchar2s with Oracle 8i/9i

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.

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.
Received on Mon Mar 18 2002 - 09:10:04 CST