Posted: Tue Dec 20, 2016 1:21 am Post subject: Not able to set db values into Env.variable
Newbie
Joined: 18 Dec 2016 Posts: 1
Hi All,
I am trying to run Airlines sample in iib9,it isnot picking any values from database and storing into Environment.variables.
I am sure it is able to connect to db because when there was no table created it was throwing me error of ORA-00942: table or view does not exist while debugging,once i created table and data that error did not reoccur.Request you all to help me.
Code:
Code:
SET Environment.Variables =
THE (SELECT T.* FROM Database.XMLFLIGHTTB AS T
WHERE T.FLIGHTDATE = Root.XMLNSC.Reservation.FlightDetails.FlightDate
AND T.FLIGHTNO = Root.XMLNSC.Reservation.FlightDetails.FlightNumber);
DECLARE ref REFERENCE TO Root.XMLNSC.Reservation.ListOfPassengers.PassengerDetails[1];
-- track the remaining number of seats
SET Environment.Variables.EconomyClassRemain = CAST(Environment.Variables.TOTALECONOMIC AS INTEGER);
SET Environment.Variables.FirstClassRemain = CAST(Environment.Variables.TOTALFIRST AS INTEGER);
You will find it hard to debug when everything is on one line.
I suggest that you extract the various parts into separate lines of ESQL and then assemble the query. The error will become obvious quite quickly.
Or better (if you are allowed to) take a user trace; it will tell you exactly what is going on.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum