Home > database >  PLSQL link remote library (notes) for self-use
PLSQL link remote library (notes) for self-use

Time:10-16

Own when installing PLSQL stepped on record the pit is simple,
Step 1: download PLSQL:https://www.allroundautomations.com/registered/plsqldev.html
Specific installation steps not capture one by one, a lot of online, mostly lazy ~ ~ ~ ~ ~ ~

Step 2: go to the website to download the Oracle client: http://www.oracle.com/technetwork/topics/winsoft-085727.html

Still need to pay attention to in after download the Oracle client folder oci. The DLL peer directory:
1, create a new file called: tnsnames. Add the following ora content

2, create a new file called: sqlnet. Ora content below
SQLNET. AUTHENTICATION_SERVICES=(NTS)
NAMES. DIRECTORY_PATH=(TNSNAMES EZCONNECT)

(note: to ensure PLSQL with oracle client for 32 bit or 64 bit)
Step 3: configure PLSQL connection

Step 4: new environment variables: configuration TNS_ADMIN, corresponding path is your local Oracle client directory, this also need to do the corresponding configuration in the path,


I step on the hole is in the NLS_LANG environment variable configuration, a lot of search on the net post is to configure the SIMPLIFIED CHINESE_CHINA. ZHS16GBK, this code, I will follow the configuration, the result has been an error ORA 12705, then read a post, don't need to configure the environment variables, I tried, Bingo, perfect start PLSQL,
If the query results will have? That kind of coding problem, performs the select in your PLSQL userenv (" language ") from dual; Find out your corresponding coding, new in the environment variable, OK, here is my environment variable

Can under reference, but the problem is differ, does not necessarily guarantee can solve,


  • Related