如何在Oracle 11gr2中安装过程选项 [英] How to install Procedural Option in Oracle 11gr2
问题描述
我一直在尝试在计算机上的Oracle 11gR2的本地安装上创建PL/SQL程序包并运行过程,但一直出现ORA-00900错误.根据此文章,似乎尚未安装过程选项. /p>
这是我登录时sqlplus的输出:
C:\Users\NgCH>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 14 13:11:34 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: system@orcl
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL>
如何安装?如果必须重新安装Oracle,必须在安装程序中选择哪些选项?我选择了企业版桌面类.
谢谢.
这是我尝试在DBeavor(64位)v2.0.6中执行的非常简单的程序包代码,它使用Oracle精简连接到本地Oracle数据库:
CREATE OR REPLACE PACKAGE TEST AS
hello_world constant varchar(20) := 'hello world';
END TEST;
来自DBeavor的错误:
Error occurred during SQL query execution
Reason:
SQL Error [900] [42000]: ORA-00900: invalid SQL statement
我已按照注释中的建议进行操作,并了解到我的问题根本与我的Oracle数据库安装无关.
在尝试运行某些pl/sql脚本时,我正在使用DBeaver,由于某种原因,我不知道它在ORA-00900中失败了.发布问题后,我在Toad for Oracle中运行了相同的脚本,它可以正常工作.在SQL Plus中运行相同的脚本也可以.
我还不知道是什么导致DBeaver中的错误,但是至少现在我知道错误代码ORA-00900并不意味着我的数据库缺少任何过程选项功能.事后看来,在发布问题之前,我可能应该先在SQL Plus中测试了我的脚本.
无论如何,感谢你们的评论,这确实帮助了我很多.
I've been trying to create PL/SQL packages and running procedures on a local installation of Oracle 11gR2 on my computer, and I kept getting ORA-00900 error. Based on this article, it seems like Procedural Option has not been not installed.
This is the output of sqlplus when I logged in:
C:\Users\NgCH>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 14 13:11:34 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: system@orcl
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL>
How can I install it? If I've to reinstall Oracle, what are the options I must choose in the installer? I chosen Enterprise Edition, Desktop Class.
Thanks.
Edit:
This is very simple package code I tried to execute in DBeavor (64-bit) v2.0.6, to a local Oracle database with Oracle thin connection:
CREATE OR REPLACE PACKAGE TEST AS
hello_world constant varchar(20) := 'hello world';
END TEST;
Error from DBeavor:
Error occurred during SQL query execution
Reason:
SQL Error [900] [42000]: ORA-00900: invalid SQL statement
I've followed the advice in the comments and learnt that my problem isn't with my Oracle database installation at all.
I was using DBeaver while attempting to run some pl/sql script, and for some reason I don't know it failed with the ORA-00900. After posting the question I ran the same script in Toad for Oracle, and it works without any problem. Running the same script in SQL Plus also works okay.
I don't know what causes the error in DBeaver yet, but at least now I know the error code ORA-00900 does not mean my database is missing any Procedural Option function. In hindsight I probably should have tested my script in SQL Plus first before posting the question.
Anyway, thanks for the comments guys, it really helped me tons.
这篇关于如何在Oracle 11gr2中安装过程选项的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!