CODEWITHSUNDEEP
sqloracle-databaseplsqloracle-apex
Kushagra S
Kushagra S

Reputation: 46

Why do I get Invalid Character ORA-00911 error message on Oracle Apex?

I have a table for marking attendance of a student. The table has three columns Attended_days, Absent_days and Registered_email. I need to display a pie chart at the dash which shows the number of days a student was present vs. the number of days the student was absent. When I add a where clause to the chart reg_email = ':APP_USER', I get the following error: Region → Attendance → Source → Where Clause ORA-20999: Failed to parse SQL query! ORA-06550: line 6, column 6: ORA-01740: missing double quote in identifier

I searched the web and tried various methods but none worked. Any suggestions or any better way to do this.

Upvotes: 0

Views: 585

Answers (1)

damir huselja
damir huselja

Reputation: 171

You shouldn't use reg_email = ':APP_USER' rather reg_email = :APP_USER, if you surround :APP_USER with quotes it becomes a litteral not the APP_USER variable

Upvotes: 1

Related Questions