Forum Stats

  • 3,815,385 Users
  • 2,259,012 Discussions
  • 7,893,063 Comments

Discussions

SQLcl and connection in the DBTools Cloud service

jariola
jariola Member Posts: 10,735 Silver Crown
edited Apr 25, 2022 8:11PM in SQLcl

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>