I found strange issue when using connection in the DBTools Cloud service.
Call to dbms_output.put_line don't show anything.
Runnin command rest export gives SP2-0640: Not connected
Here is what I did try.
$ sql /nolog
SQLcl: Release 22.1 Production on Mon Apr 25 23:00:53 2022
Copyright (c) 1982, 2022, Oracle. All rights reserved.
SQL> oci profile DEV
Region set to: us-ashburn-1
OCI Profile set to DEV
Transfer method set to oci
SQL> conn ocid1.databasetoolsconnection.oc1.us-ashburn-1.xxxxx
Retrieving Connection Details
Retrieving Wallet
Establishing Connection
Connected.
SQL> set serveroutput on
SQL> set feedback off
SQL>
SQL> begin
2 dbms_output.put_line('hello, hello');
3 end;
4* /
SQL>
SQL> rest export
SP2-0640: Not connected
SQL>
SQL> select * from dual;
DUMMY
________
X
SQL>