I'm moving some SQL code from SQL Developer into an RMD. ROracle connects to the DB and runs simple select-from-where statements without issue. Any command that does not begin with SELECT seems to fail though.
I'm particular I'm trying:
alter session set global_names = false
set escape on
define DATE = to_date('01-JAN-21', 'DD-MON-YY')
These run without issue in SQL Developer where they are necessary for the main SQL script to execute.
Are these functions not supported in ROracle? Any ideas or workarounds?