Igor's Blog

We've updated some of our databases to 12c recently, at the same time I was working on an issue in some of the PL/SQL packages that I've built and running some tests on these. To my surprise when I tried to run my test PL/SQL procedure, SQL Developer was not showing in its run dialog.

I tried to see if the same procedure would execute by writing an anonymous PL/SQL block and it did.

This is what SQL Developer (4.0.2) was showing me...The package clearly defines a procedure, but it is not visible in the run dialog box, instead SQL Developer is reporting an empty package definition (no public members).
sqldev12cplsqlbug3.png


I checked the DB version and the results were 12.1.0.2.0.
sqldev12cplsqlbug2.png


Thinking this is a 12c related problem, I connected to a different database that has not been upgraded, still at 11gR2 level, lo and behold, my procedure was visible in the run dialogue again. Definitely a 12c related issue then.

The DBA suggested that I try SQL Developer 4.1 Early Adopter to see if that helps. It did! Looks like SQL Developer 4.0.x is not fully compatible with 12.1.0.2 version of the database.

The fixed bug list confirms this...
sqldev12cplsqlbug1.png




Looking deeper into the bug it only seems to affect 12.1.0.2.0 database version, if you are on 12.1.0.1.0, this problem does not show up.

So there you go, if you got the latest DB version, the latest SQL Developer fixes this little problem!

-i

, , , ,
About — I'm an enthusiastic software engineer and consultant interested in many fields including J2EE, programming, electronics, 3D printing, video games, wood working and gardening.
See my Resume for more information.
The views expressed in this blog are my own and not those of my employer.
comments powered by Disqus
My other posts you may like...
Programming, DIY, Games, Hacks, Tech and more.
Follow me on...
Current and Past Projects
See my Resume

Subscribe


RSS Feed

My Other Web Sites

Igor and Elise's Travels
Riverside Expressway Cam
StrFunc() Online
300 George St Blogumentary
Guru JSON-RPC Tester
Extrudifier Object Designer

Recent Blog Posts

Binding extra variables with PHP PDO returns no results

New Nintendo 3DS XL, R4i SDHC RTS Lite and DSDoom

Older versions of JD-GUI crashing on macOS Sierra

How does Seeed Fusion stack up as a low budget PCB fab

Where to find the last item (Robbie's lost lyrics) in GravityFalls Lake level

Detecting print requests to print contents of a DIV with JavaScript

Using Google DFP with AdSense on responsive pages

How to change the email subject line in Gmail

Force PHP GD library to load JPEG images that have invalid data

How to uninstall Samsung Smart Switch from your Mac

Recent Galleries

Space Food - Chocolate Ice Cream with Chocolate Chips

Legeod Star Wars AT-DP kit

DIY spare parts computer build with a RAIDMAX Anura case

Fake 'Lepin' brand Lego packaging

Hardwood garden bench with clear resin void filler

Fixing a 3D printer extruder that stopped heating up

Easily increase disk space in a Lenovo Ideapad 100S 14" laptop with an M.2 SSD

Making a multi-piece 3D printed solder spool holder stand

DIY indoor apartment grow light wiring

Good Friday Electronics fun Easter Bunny LED PCB Kit IBEABU-01.0

Top Categories

Blogs I follow

Matt Moores Blog
Georgi's FlatPress Guide
Perplexing Permutations
The Security Sleuth

Friends

RAWS Parts Online
Alpha Dimensions Hosting
Kristensen Photography
Ilia Rogatchevski
Travelling Fairy

Blog Activity

Blog Activity
Follow me on... 
     
...or subscribe for updates!

Don't show this again