Limitations of the Native dynamic Sql and Case expressions

Hi,

I have two questions.
I am working with Oracle 8i.

If you don’t have the answers I will be happy to read any documentation that can help me.

First Question:
Is there any one who knows what is the longest character string I can pass into an ‘open for’ statement?

OPEN c_Cusor FOR
‘Select *

 from test….what is the longest length of the string I can pass to the open statement’

I have looked into the documentation and it says that the DBMS_SQL supports statements that are more than 32KB in length. Since they were comparing between DBMS_SQL and native dynamic sql I assumed that NDS was not able to support statements that are more than 32KB.

I have tested the OPEN FOR statement with a select statement over than 32KB and it worked.

Second question:
In the select statement of the OPEN FOR statement I use a CASE expression.

The documentation says the following:

‘The maximum number of arguments in a CASE expression is 255,
and each WHEN ... THEN pair counts as two arguments. To avoid exceeding the limit of 128 choices, you can nest CASE expressions.
‘

I have tested the case statement with over 128 choices and it worked. Is there any one who have information about that?

Thanks in advance
Lolita Received on Mon Apr 07 2003 - 13:04:59 CDT