Re: Oracle developer 2000 - forms

From: hr60112 <hr60112_at_swt.edu>
Date: Mon, 04 Dec 2000 19:34:18 +0000
Message-ID: <3A2BF1B9.D61B2B68_at_swt.edu>

My problem in developer 2000 forms is
I have two tables in the database,
[Quoted] 1)CarDetails - cd_no:ofdays , cd_totalmiles, etc... 2)CarRentals - cr_milesperday , etc..
  In my form for CarDetails, I want to update totalmiles by multiplying no:ofdays (of CarDetails form) and
milesperday(of the CarRentals table).
I wrote a trigger
DECLARE
 X NUMBER;
 Y NUMBER;
  Z NUMBER;
BEGIN

 SELECT CR_MILESPERDAY INTO X FROM CARRENTALS
 WHERE :CD_CARCODE = CARRENTALS.CR_CARCODE;
 SELECT CD_DAYSHIRED INTO Y FROM CARDETAILS

 WHERE CD_CARID = :CARDETAILS.CD_CARID;
 Z := X*Y;
 INSERT INTO CARDETAILS (CD_TOTALMILES) VALUES   (Z);
COMMIT;
SELECT CD_TOTALMILES INTO :CD_AMOUNT FROM CARDETAILS WHERE CD_CARID = :CARDETAILS.CD_CARID;
END; But it returns a error during the run time, ORA-01400. How do i rectify it. Please reply.
Thank you.
from hamsinirs_at_hotmail.com Received on Mon Dec 04 2000 - 20:34:18 CET