Create Table – ORA-00907: missing right parenthesis — CHECK and DEFAULT Order Swapped

AshokTechnical TipsLeave a Comment

Most people, including myself, don’t memorize the syntax and associated options for every programming language. So, I was interested in determining what the issue was with the following create table command that one of my developers was having. He continued to receive the following error, regardless of what he did with parentheses: ORA-00907: missing right parenthesis CREATE TABLE AppItem (id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(100), url VARCHAR(100), required CHAR(1) CHECK (required IN(’N’,’Y’)) DEFAULT ‘N’, img VARCHAR(100), title VARCHAR(100), description VARCHAR(100) );CREATE TABLE AppItem (id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(100), url VARCHAR(100), required CHAR(1) CHECK (required IN(‘N’,’Y’)) … Read More

WebLogic 11g (10.3.4) Install on Windows – WLS 11gR3

AshokTechnical Tips2 Comments

I documented the steps I took to complete an install of WebLogic 11g PS3 (10.3.4) — sometimes also called 11gR3 — on my Windows 7 Ultimate 64-bit OS. There is only a 32-bit version of WebLogic available for Windows, but it runs fine on Windows 7 64-bit and, as I understand, the same way with other version of the Windows OS as well (Vista, XP, Servers, etc.). [box type=”shadow”]Note: The WebLogic Server version is 10.3.4, but this release coincides with other Oracle Fusion Middleware products released with a version numbering of 11.1.1.4.[/box] This walk-through covers: WebLogic 11g Install on Windows … Read More

WebCenter 11g Book – Hello World Examples, Screenshots, and Tutorials

AshokNews and Updates, Offerings, Technical TipsLeave a Comment

Our WebCenter 11g book has been out a few weeks and I have heard some good reviews from people who have picked it up. This version 1 book will quickly get you started with WebCenter 11g, providing you step-by-step screenshots on creating your environment followed by a Hello World web service that is exposed to the web as a WebCenter portlet among other common business scenarios you may need to accomplish.

JDeveloper 11g Tutorial – Install Steps (11.1.1.3.0)

AshokTechnical TipsLeave a Comment

New versions of JDeveloper 11g have been released since the last step-by-step JDev install guide, so I thought I would post a quick refresher for anyone who wants that comfort of knowing they are seeing the screens they should expect to see as they march through the install. Enjoy; the product really is getting better and better everyday. Installing JDeveloper 11g (11.1.1.3.0) on Windows

Oracle DBMS_SCHEDULER vs DBMS_JOB (Create, Run, Monitor, Remove)

Ben MarckTechnical TipsLeave a Comment

DBMS_SCHEDULER is a newer, more complex job scheduling engine released in 10g, intended to replace DBMS_JOB going forward. DBMS_JOB, the older job scheduler, as of now is still available for quick and easy DB based job scheduling.

Job scheduling comprises the core of the functionality of DBMS_SCHUDULER, however here are some additional benefits available to DBMS_SCHEDULER:

  • Logging of job runs (job history)
  • Simple but powerful scheduling syntax (similar to but more powerful than cron syntax)
  • Running of jobs outside of the database on the operating system (see below)
  • Resource management between different classes of jobs
  • Use of job arguments including passing of objects into stored procedures
  • Privilege-based security model for jobs
  • Naming of jobs and comments in jobs
  • Stored, reusable schedules

TOAD for Oracle 9 or TOAD 10 – 64-bit Windows – ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open

AshokTechnical Tips86 Comments

I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x, no problem. This really threw me off for a minute, so I thought I would share the resolution. You are likely running a 64-bit Windows OS and have installed TOAD into C:\Program Files (x86)\…. I simply copied over my entire Quest Software directory from C:\Program Files (x86)\… to C:\Program Files\…, and restarted the TOAD.exe. Everything is working great, without having to reinstall anything. PS: Not sure who to blame here. Vendors (like Oracle and TOAD) should know Microsoft is capable … Read More