Home » Developer & Programmer » Forms » POST-QUERY causes ORA-01422 after migrating to Forms 6i
POST-QUERY causes ORA-01422 after migrating to Forms 6i [message #79216] Wed, 15 May 2002 10:31 Go to next message
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
Re: POST-QUERY causes ORA-01422 after migrating to Forms 6i [message #79220 is a reply to message #79216] Wed, 15 May 2002 13:07 Go to previous messageGo to next message
Nina
Messages: 113
Registered: March 2000
Senior Member
Nevermind. Catched TOO_MANY_ROWS exception in 6i. Apparently, it was possible to get away with this exception in 4.5 and still get data..I guess 6i is not as forgiving....

Nina
Re: POST-QUERY causes ORA-01422 after migrating to Forms 6i [message #79230 is a reply to message #79216] Wed, 15 May 2002 23:59 Go to previous message
George Lam
Messages: 2
Registered: May 2002
Junior Member
Try to generate your source by the Form Generator (Don't generate in the Form Builder) and it will solve the above problem.
Previous Topic: FORMS picture on button
Next Topic: Changing Fr.Ground & Bk.Ground Color of Push Button
Goto Forum:
  


Current Time: Thu Jun 04 04:21:36 CDT 2020