Re: varchar2s with Oracle 8i/9i

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