All good things must come to an end. It has been a long run with plenty of ups and downs. Getting Discoverer rolled out was one of my first tasks as I embarked upon my +Oracle E-Business Suite journey. Alas, we are saying our final goodbyes to Discoverer. This however opens new doors to address our reporting …
Category: SQLDev
Installing SQL Dev 4.0 (JRE 1.6 and JDK 1.7)
I’m in an environment where our 11i version of EBS (I know we need to upgrade) still requires JRE 1.6 to open Oracle Forms. Being an SQL Developer fan (listen to my podcast here), I decided to download and install SQL Dev 4.0. Anyone that’s been following this knows that the latest release requires JDK …
Use Start-up Script to Modify State of your Pluggable Database to Open Read Write in SQL Developer 4.0 EA3 (ORA-01033)
I’m playing around with Oracle’s SQL Developer 4 EA3 and Database 12c. Using SQL Dev, I quickly created a Pluggable Database (PDB). I try to open it, and I get this (ORA-01033). Then I remember reading that the Pluggable Databases don’t open automatically when the database services are started. Well that sucks because now I …
Virtual Columns, Table Export, and Forums: A Love Hate Relationship (SQL Error: ORA-54013: INSERT operation disallowed on virtual columns)
Ok, so kind of a weird title, but let me explain. I believe that when you post to a forum, you are either seeking knowledge or sharing it. I was on the SQLDev forum a few days ago, and someone posted what can be perceived as an error when exporting a table. Here is what …
Can I run SQL Scripts via HTTP?
I saw this question via Twitter not to long ago, and then it came up again in a brief conversation with +Bobby Curtis, and it was about running SQL scripts over HTTP. So if you are interested, here is a quick post on how to do just that. Say you have a ton of extremely useful scripts …
Oracle Open World 2013 – Wrap up (#OOW13)
So if you know anything about me, you will know that I am always amp’d up when it’s time for Oracle Open World. This year was quite a different experience for me. In previous years, I found myself running all across the Conference Complex attending session after session. This year however, I took a different …