SQLcl and connection in the DBTools Cloud service

jariola

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>