Passing output of JDBC API for control flow
Hi,
I am trying to create a login application through JDBC API. If login is "Success", then control to go to "Login Success" page else to "Login failed" page. I created a JDBC API where I am calling a PL/SQL procedure (two IN parameters for login id & password & one OUT parameter to return value) to check the parameters & return Success/Fail as a value. I created a data control from the above created JDBC API & then dragged & dropped as a ADF form.
When I run this, though the JDBC API is returing "Success" or "Fail" correctly (I can observe this from the log), the "page flow movement" is not happening.
How to achieve this? Any better way to hit a database table for the login screen?