usql icon indicating copy to clipboard operation
usql copied to clipboard

oracle: PL/SQL Block

Open markuman opened this issue 3 years ago • 0 comments

It looks like usql dosn't support oracle PL/SQL blocks

DECLARE
  l_message VARCHAR2( 255 ) := 'Hello World!';
BEGIN
  DBMS_OUTPUT.PUT_LINE( l_message );
END;
/

usql oracle://user:[email protected]/BIPDB -f /tmp/hello.sql --single-transaction
Connected with driver oracle (Oracle Database 19.0.0.0.0)
error: oracle: ORA-06550: line 2, column 45:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   * & = - + ; < / > at in is mod remainder not rem
   <an exponent (**)> <> or != or ~= >= <= <> and or like like2
   like4 likec between || multiset member submultiset
error: oracle: ORA-06550: line 2, column 35:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   := . ( % ;
error: oracle: ORA-00900: invalid SQL statement

markuman avatar Jul 29 '22 06:07 markuman