Re: Problems with Select Max on Date Field

From: John Gibson <jogibson_at_utmb.edu>
Date: 1998/03/02
Message-ID: <34FB2E93.3D72@utmb.edu>#1/1

stevec_at_zimmer.csufresno.edu wrote:
>
> Are you aware that your text is loading about 950 characters into
> variable v_sql_statement? If you don't have it defined as
> varchar2(1000) or larger, then that is the problem.
>
> If I were writing the code, I would put quotes around each line and
> use concatenation. This would eliminate your unnecessary blank
> padding in the actual SQL statement.
>

That was it Steve. I had the field size set at 500. I can't believe I missed that. Thanks for your help. Received on Mon Mar 02 1998 - 00:00:00 CST