I've done a lot of Oracle data access via MS Access & VBA recently and found the various syntax very fussy. Have had to put ( ) in several place that I did not expect.

It's not clear from your post where the SQL is being executed.

HTH

****