Re: varchar2s with Oracle 8i/9i

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