Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl and connection in the DBTools Cloud service

jariolaApr 25 2022 — edited Apr 25 2022

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> 


Comments

Post Details

Added on Apr 25 2022
0 comments
100 views