Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem is the pl/sql variable can have only 1000 bytes despite being varchar2(4000) is that a bug?

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 07 Jun 2005 19:06:24 +0200
Message-ID: <8skba1plrhcg9ijrc5hpqereipb8ag0i29@4ax.com> 





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.



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Jun 07 2005 - 12:06:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US