usql
usql copied to clipboard
oracle: PL/SQL Block
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