For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
HI All
Please share your thoughts.
The update is not happening in the target and its getting error no data found
when I checked in the source the row exist and table has PK
OGG :- 12.3
DB :- 11.2.4
thanks in advance
Regards,
DR
It's funny that the day before, I get stumped by a problem the whole day... then the next day I find the answer to my problem.
The view is actually working. but the last record is not appearing. This is the same for my tables. no last record.
I get 3 rows in the table in the SQL Command Line.
I get 2 rows in the view in the SQL Command Line.
I get 2 rows in the table in the PHP Web page.
I get 1 row in the view in the PHP Web page.
I have only changed the select statement, the rest of the code is the same.
help?
OK, I have just figured it out.
Oracle 11g XE allows for one session. Connecting to Oracle through PHP counts as a session.
Disconnecting the console fixed the problem.
You can have more than one session at a time to XE. At a guess, you hadn't committed in the first session and disconnecting performed the commit for you. This let the other session see the data.