Thank you, TheOC, for the information! Yes, adding the "parameter" is the fix but I don't seem to be able to find this option in setting up the external connection (the only available options are host, port, username, and password). Yes we have been using the jdbc connection to programmatically connect to oracle but we are just exploring the lakehouse federation way to reading data from oracle, a very old oracle database.

Thanks so much!