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�
- https://forums.oracle.com/forums/thread.jspa?threadID=2321010
- http://bigsnowball.com/content/fixing-sqldeveloper-msvcr71dll-not-found-error
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�
- https://forums.oracle.com/forums/thread.jspa?threadID=2321010
- http://bigsnowball.com/content/fixing-sqldeveloper-msvcr71dll-not-found-error
Comments