Sims 1 Superstar Skinseed. Jun 03, 2014 Step by Step procedure to install Oracle. Sandy E Junior Acustico Mtv Download Dvd on this page. SQL>select * from v$option where parameter='Oracle. Disconnected from Oracle Database 11g. STEPS TO INSTALL ORACLE ON YOUR WINDOWS MACHINE. Downloading Oracle 11g Release 2. Download Free Elvis Recorded Live Stage Memphis Rar Software. Select Configure and Database Option. Sample schema used for Oracle OLAP 11g Oracle. With Oracle OLAP Option enabled; Installation. You should be logged on as a DBA to execute this procedure.
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, 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: 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. 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.