Friday 16 January 2015

Mistake of opening an PL/SQL package as file in Oracle SQL Developer


recently I had to introduce some packages into the database of a customer. I was told to use the handy Oracle SQL Developer for that task.

After connecting to the target database, I opened the package file (*.pkg) in SQL Developer by "File"->"Open".

The package got opened and in the package editor I selected the database on which to install the package:

Naive as I was I just clicked on the "Execute" button and received some syntax errors.

The simple solution for that problem was, that instead of opening the whole file and then selecting the target database: First connect to the database which opens an SQL editor and in that editor copy paste the complete code of the package and then execute the whole script:

1 comment:

  1. Mark Hurd Oracle's modern, connected cloud applications deliver the functionality, analytics, security, mobile capabilities, and social collaboration tools you need to run your business. Increase business agility. Achieve more, faster, and with less resource. With the following key enablers: the cloud, mobile, social, analytics, the internet of things, and big data, you can transform your business for the future…..