Re: date problem in migrating Oracle Forms&Reports 4 to Oracle Forms&Reports 6
Date: 27 Dec 2002 03:13:57 -0800
Message-ID: <8288bbda.0212270313.79d8ba84_at_posting.google.com>
Thanks Frank for your answer.
My operating system is Win2000 Professional and my client settings as
these are specified in my registry are
Ok let me give you a snapshot from the Stored procedure where the date
problem is found:
Let me give you some more detail regarding this date problem.
NLS_DATE_FORMAT (in table 'nls_session_parameters') : DD/MON/RR
NLS_DATE_FORMAT (in table 'nls_database_parameters') : DD/MON/YY
NLS_DATE_FORMAT (in table 'nls_instance_parameters') : null
/* --------------------------------------------------*/
PROCEDURE OU550_S12(p_start_date1 IN date,
p_last_date1 IN date,
P_RC OUT NUMBER) IS
....
....
CURSOR acco_cursor IS
SELECT acco_trans_number, entry_date_time
FROM accounts_transactions
WHERE entry_date_time BETWEEN p_start_date AND p_last_date
ORDER BY receipt_no ASC;
*/
Comments:
close acco_cursor;
/*--------------------------------------------------*/
While the above query fetches the correct result when it is executed
from a)the SQL Plus environment and b) from with in a program unit in
Thanks a lot in advance. Any help will be precious to me Received on Fri Dec 27 2002 - 12:13:57 CET