Showing posts with label sqldeveloper. Show all posts
Showing posts with label sqldeveloper. Show all posts

Saturday, February 11, 2012

...and now learning pl/sql with oracle 11g

For this adeventourus matter, I am using SQLDeveloper environment to program PL/SQL. This software is quite easy to use. There are current versions at the Oracle site, depending on your OS you may download the Linux version, the Mac or even the MS version with installer.

I personally use an old version, in my MS 7 64bit, but installing SQL developer for 32bits with JDK1.6.xx included. There may be sometimes an error stating MSVCR71.dll is missing. To fix this up:


- unzip the SQLdeveloper zip folder
- Go to ..\jdk\jre\bin copy MSVCR71.dll file
- Go to ..\sqldeveloper\bin and paste the dll file
- Run  .\sqldeveloper.exe

This should work and now you can open a connection to start creating your PL/SQL programms.




More help:
- https://forums.oracle.com/forums/thread.jspa?messageID=9989738&#9989738
- https://forums.oracle.com/forums/thread.jspa?threadID=2321010
- http://bigsnowball.com/content/fixing-sqldeveloper-msvcr71dll-not-found-error