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 can't catch the no_data_found exception in for any more. Once this no_data_found Oracle occurs, it automatically jumps out of the for loop, but I don't know what went wrong, that was depressing for an hour. Shit. Later I remembered that pl/SQL tools could be debugged.
Www.2cto.com, But I think of pl/SQL installation, there are no 64-bit companies. If I don't want to think about Oracle companies like this, I don't even know 64. Later, I took it as a saying, post an article about installing a pl/SQL www.2cto.com 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, I have struggled with this issue for several days. I finally solved it by asking Google + for hands-on practice. Now, I will record the process of solving the problem and share it with netizens who encounter the same problem. First download a 32-bit client (instantclient) on the Oracle official website. Be sure to download the basic version instead of 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. ora to the oracle \ product \ instantclient_10_2 \ directory. Next, set the environment variable. [Html] variable name: TNS_ADMIN variable value: D: \ oracle \ product \ instantclient_10_2 after setting the environment variable, create the start. bat file in the directory of PLSQL Developer. The following is the content of start. bat: [python]
@ Echo offset path = D: \ oracle \ product \ instantclient_10_2set ORACLE_HOME = D: \ oracle \ product \ instantclient_10_2set TNS_ADMIN = D: \ oracle \ product \ instantclient_10_2set NLS_LANG = AMERICAN_AMERICA.ZHS16GBKstart plsqldev.exe where 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.