CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle-apex-19.1
sbl
sbl

Reputation: 39

Unable to bind Application item - Oracle Apex

I have created 2 application items in shared component option.

Then I have created a process in the login page where sql query is

select user_id, name into :G_USER_ID , :G_USER_NAME
from t_users
where upper(email) = upper(:P9999_USERNAME);

When I try to login it gives me error. Debugging says that there is an error in the above statement. I am not able to bind these items.

I'm using apex 19.1

Upvotes: 0

Views: 412

Answers (1)

Littlefoot
Littlefoot

Reputation: 142753

It would help if you said which error you got.

However, if this piece of code runs before you managed to log in, you didn't establish connection to the database (yet) and can't select from any table, including t_users.

Upvotes: 0

Related Questions