SquirreL SQL Client 3.7.1上的PL/SQL [英] PL/SQL on SquirreL SQL Client 3.7.1

问题描述

我试图在SQuirrel上执行PL/SQL脚本，但似乎不起作用.

I was trying to execute PL/SQL scripts on SQuirrel but it doesn't seem to work.

我通过在额外的类路径"上添加ojdbc7.jar来配置Oracle Thin Driver，它能够连接到数据库，但是当尝试运行简单的代码时会出现错误:

I configured Oracle Thin Driver by adding ojdbc7.jar on "Extra Class Path", was able to connect to the database but when tried to run a simple code it gives an error:

-- code
BEGIN
  dbms_output.put_line('Hello World');
END;
/

-- error
Error: ORA-06550: line 2, column 37:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

:= . ( % ;

SQLState:  65000
ErrorCode: 6550
Error occurred in:
BEGIN
  dbms_output.put_line('Hello World')

我做错什么了吗?

推荐答案

此语句对我有用(/对于SQuirrel SQL Client是必需的):

This statement worked for me (the / is necessary for SQuirrel SQL Client):

BEGIN
    dbms_output.put_line('Hello World');
END;
/

但是，您不会在通常的结果"标签中看到输出.您需要打开"Oracle数据库输出"窗口.据我所知，您只能使用工具栏上的按钮将其打开.您还需要启用自动刷新或手动刷新输出.

However, you won't see the output in the usual Results tab. You need to open the Oracle Database Output window. As far as I can see you can only open it with a button on the toolbar. You'll also need to enable auto refresh or manually refresh the output.

这篇关于SquirreL SQL Client 3.7.1上的PL/SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！