Re: Problem is the pl/sql variable can have only 1000 bytes despite being varchar2(4000) is that a bug?

In article <8skba1plrhcg9ijrc5hpqereipb8ag0i29_at_4ax.com>, sybrandb_at_hccnet.verwijderdit.nl wrote:
>On 7 Jun 2005 09:37:04 -0500, colin_lyse_at_98fgfgs.com (colin_lyse)
>wrote:
>
>>>and got the same error.
>>>
>>>any ideas?!
>
>The maximum length of a varchar2 in pl/sql in 32767 bytes (32k)
>There are limitations to the length of a statement, you would need to
>look them up in the Oracle reference manual.
>Secondly as the aliases you are using are fully redundant, as the
>table qualifiers are automatically stripped. Using aliases like this
>is typically the sqlserver way to misuse sql.
>Thirdly you are not running the most recent patch for Oracle 9i.
>
>

thanks for your reply if great to have a real guru response. the problem I am experiening is quite wierd

-looking thru all docs i counld see nothing about a 1000 character limit on a -variable

-the programmer is a sqlserver guy who is learning oracle

• yes we are at an older verison our DBA says he is too busy to patch yet!!

I determine the problem is that is that the if the sqlStmt statement exceeds 1000 characters then i get the Undeclared Identifier ' sqlStmt' error. if i make it < 1001 there is no problem.

I have the variable set to varchar2(4000) why does it fail at 1001 characters? makes no sense. Is it the way i am doing it? Received on Tue Jun 07 2005 - 13:09:02 CDT