Oracle Stored Procedure debugging and PL/SQL installation in 64-bit operating system (prompt that Oracle has been installed before PL/SQL installation)

Today, I am working on an OA report. I use a stored procedure to calculate some data. When doing a for XXX in xxxx loop end loop; loop,

I never knew it was Mao. I cannot catch the no_data_found exception in for any more. Once this no_data_found occurs

Oracle will automatically Jump Out Of The for loop, but I don't know where the error occurred. It was a depressing hour. Shit.

Later I remembered that PL/SQL tools could be debugged.

However, when I was installing PL/SQL, I remembered that there were no 64-bit companies. I didn't think that Oracle was a company like this, but I did not know 64. After Google, I came up with it, post an article to install a PL/SQL in 64-bit

Since PLSQL developer does not have a 64-bit version, an error will be reported when running this link on a 64-bit System for 64-bit oracle. I have been struggling with this problem for several days, later, I finally solved this problem by asking Google + hands-on practices. Now, I will record the process of solving the problem and share it with netizens who encounter the same problem.

First download32-bit(Instantclient), be sure to download the basic version, do not download the basiclite version. I first downloaded the basiclite version, but the result was poor. Later, I found that basiclite is much smaller than the basic version. I guess it may be a lack of components.

The pen uses instantclient-basic-win32-10.2.0.5.zip, which is provided here.

First, extract the downloaded client, and then decompress it to the Oracle Installation Directory (D: \ oracle \ product \ instantclient_10_2 ).

Copy D: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \Tnsnames. oraGo to the oracle \ product \ instantclient_10_2 \ directory.

Next, set the environment variable.

 
Variable name: tns_admin variable value: D: \ oracle \ product \ instantclient_10_2
 

After setting environment variables, create the start. BAT file in the directory of PLSQL developer.

The following is the content of start. BAT:

 
@ Echo off set Path = D: \ oracle \ product \ export ORACLE_HOME = D: \ oracle \ product \ instantclient_10_2set tns_admin = D: \ oracle \ product \ instantclient_10_2set nls_lang = american_america.zhs16gbkstart plsqldev.exe
 

Set nls_lang = american_america.zhs16gbk zhs16gbk is your database code.

Start your PLSQL developer, but do not log on.

Click Tools → preferences → connect, set "Oracle main directory name" to null, and set "OCI library" to oci in the instantclient directory. dll path. The author's path is D: \ oracle \ product \ instantclient_10_2 \ OCI. DLL.

Save and exit PLSQL develoer, and run start. bat.

If not, restart the system and run start. bat.