在Oracle中，在JSON_VALUE()中传递动态键

I have a club type column which has Json data. I have around 100 keys which are unique to each record. we are using json_value('json_data', 'keyname'). In my case i don't know actual for this record. So i need to join with another table where there keys are defined. In place of keyname i want to pass columnname. Its giving some error saying :I have a club type column which has Json data.