Re: dynamic SQL with date queries
From: Eric Byrnes <LNUSMCD.NZJDDV_at_eds.com>
Date: 1997/02/11
Message-ID: <33010AA7.1993_at_eds.com>#1/1
Date: 1997/02/11
Message-ID: <33010AA7.1993_at_eds.com>#1/1
I think the problem here is that SYSDATE is a function, not a variable,
and therefore can't be used in this context with the DBMS_SQL packages,
which expect a character string which resolves to a static query. Try
separating this routine, i.e.
1. SELECT SYSDATE INTO a PL/SQL storage variable (using DUAL)
2. Call your routine using the PL/SQL variable you just created
Received on Tue Feb 11 1997 - 00:00:00 CET