| POST-QUERY causes ORA-01422 after migrating to Forms 6i [message #79216] |
Wed, 15 May 2002 10:31  |
Nina
Messages: 113
Registered: March 2000
|
Senior Member |
|
|
I was wondering if anyone is having similar problem after upgrading to Forms 6i. We have recently migrated from Forms 4.5 to Forms 6i in the following environment: Oracle 8.1.6
AIX 4.3
Forms 6.0.8.15.0
Apparently after the migration, POST-QUERY fails to populate items. It populates everything fine in 4.5 version. Where there any changes in the behavior of this trigger? What can be causing such change in behavior.
Code Example:
BEGIN
SELECT CUSTOMER_ID,SUBSTR((CUSTOMER_LAST_NAME||','|| CUSTOMER_FIRST_NAME||
' ' || CUSTOMER_MI),1,30),COLUMN1_TYPE,COLUMN2_STATUS,
TO_CHAR(COLUMN2_ACTIVITY_DATE,'DD-MON-YYYY')
INTO :CUSTOMER_ID,:CUSTOMER_NAME,:COLUMN1_TYPE,:COLUMN2_STATUS,
:COLUMN2_ACTIVITY_DATE
FROM CUSTOMERS,TABLE1,TABLE2,TABLE3
WHERE COLUMN1_POSN=:COLUMN3_POSN AND
COLUMN2_POSN=COLUMN1_POSN AND COLUMN2_EFFECTIVE_DATE <= TO_DATE(:QUERY_DATE
,'DD-MON-YYYY') AND
COLUMN4_PIDM=COLUMN2_PIDM AND COLUMN4_BEGIN_DATE <= TO_DATE(:QUERY_DATE
,'DD-MON-YYYY') AND
(COLUMN4_END_DATE >= TO_DATE(:QUERY_DATE,'DD-MON-YYYY') OR COLUMN4_END_DATE
IS NULL);--EXCEPTION
WHEN NO_DATA_FOUND THEN MESSAGE
('*ERROR* INVALID POSITION; JOBS RECORD NOT FOUND FOR THIS POSITION');
RAISE FORM_TRIGGER_FAILURE;
WHEN OTHERS THEN MESSAGE
'THERE IS ANOTHER TYPE OF ERROR HERE');
END;
---------------------------------------------
P.S :QUERY_DATE comes from the key_block
This query works fine in the POST-QUERY trigger in Forms 4.5, but not in 6i environment. Any ideas?
Regards,
Nina
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
