I am trying to write an SQL query in Oracle Apex that accesses items in the page and then creates a graph based on that item. In this case, I want to display the last 5 games of a player that the user inputs.
I have tried using v(‘P2_PLAYER’) and :P2_PLAYER to access the item value but it still does not work and my graph returns no data found. Here is the code I am using currently (it works when I simply put PLAYER = ‘Caitlin Clark’ (or any player in the database rather than PLAYER = :P2_PLAYER)
[PageSQL](https://i.sstatic.net/51Bbj7PH.png)
Kunal Kamra is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.