Author: byterock Date: Wed Feb 6 12:08:05 2008 New Revision: 10699 Modified: dbd-oracle/trunk/Oracle.pm dbd-oracle/trunk/README.win32.txt
Log: cleaning up the read mes and the pod Modified: dbd-oracle/trunk/Oracle.pm ============================================================================== --- dbd-oracle/trunk/Oracle.pm (original) +++ dbd-oracle/trunk/Oracle.pm Wed Feb 6 12:08:05 2008 @@ -1724,7 +1724,8 @@ Although many experienced DBAs will consider an 8bit character set like WE8ISO8859P1 or WE8MSWIN1252. To use any character set with Oracle other than US7ASCII, requires that the NLS_LANG environment variable be set. -See the L<"International NLS / 8-bit text issues"> section below. +See the L<"Oracle UTF8 is not UTF-8"> section below. + You are strongly urged to read the Oracle Internationalization documentation specifically with respect the choices and trade offs for creating @@ -2274,6 +2275,18 @@ PL/SQL block may contain garbage. See L<http://www.mail-archive.com/[EMAIL PROTECTED]/msg18835.html> +=head2 Avoid Using "SQL Call" + +Avoid using the "SQL Call" statment with DBD:Oracle as you might find that +DBD::Oracle will not raise an exception in some case. Specificaly if you use +"SQL Call" to run a procedure all "No data found" exceptions will be quietly +ignored and returned as null. Accorting to Oracle support this is part of the same +mechanism where; + + select (select * from dual where 0=1) from dual + +returns a null value rather than an exception. + =head1 Private database handle functions These functions are called through the method func() Modified: dbd-oracle/trunk/README.win32.txt ============================================================================== --- dbd-oracle/trunk/README.win32.txt (original) +++ dbd-oracle/trunk/README.win32.txt Wed Feb 6 12:08:05 2008 @@ -43,18 +43,20 @@ 6) You will also need the Windows SDK. Which can be found at http://www.microsoft.com/downloads/details.aspx?FamilyId=A55B6B43-E24F-4EA3-A93E-40C0EC4F68E5&displaylang=en You have the choice to of either to download the entire SDK and install or run an online install from the page. - Both have been tested and proven to work. + Both have been tested and proven to work. 7) Next download and install the Microsoft .net framework 1.1 skd from http://www.microsoft.com/downloads/details.aspx?FamilyID=9b3a2ca6-3647-4070-9f41-a333c6b9181d&displaylang=en -8) Enough Downloading and installing go have a coffee. +8) You will also need a copy of nmake.exe which you can download here http://download.microsoft.com/download/vc15/patch/1.52/w95/en-us/nmake15.exe -9) You should at this time attempt to connect to an Oracle database with the version SQL*Plus that +9) Enough Downloading and installing go have a coffee. + +10) You should at this time attempt to connect to an Oracle database with the version SQL*Plus that you installed in step 4. If you are unable to connect at this stage then any problems you encounter later may have nothing to do with DBD::Oracle -10) On the path where you installed Visual C++ find and edit the vcvars32.bat file as follows. You may have to modify +11) On the path where you installed Visual C++ find and edit the vcvars32.bat file as follows. You may have to modify these path values depending where you installed the products on you computer, i. Add the local path to the windows platform SDK include directory to the Set INCLUDE @@ -72,37 +74,37 @@ e.g. C:\Program Files\Microsoft Platform SDK\Lib; -11) Open a Windows Visual C++ command window from the start menu. +12) Open a Windows Visual C++ command window from the start menu. -12) Add the path to the instant client to the Path command. If you are compiling aginst a 10XE db/client then you can skip steps +13) Add the path to the instant client to the Path command. If you are compiling aginst a 10XE db/client then you can skip steps 12 to 14. e.g. PATH = C:/Oracle/instantclient;%PATH% -13) Using the "Set" command add "ORACLE_HOME=path to Instant client" to the environment variables. +14) Using the "Set" command add "ORACLE_HOME=path to Instant client" to the environment variables. e.g. Set ORACLE_HOME=C:\Oracle\instantclient -14) Using the "Set" command add "NLS_LANG=.WE8ISO8859P15" to the environment variables. The globalization variable is required, +15) Using the "Set" command add "NLS_LANG=.WE8ISO8859P15" to the environment variables. The globalization variable is required, with this or another compatible value, by Oracle instantclient in order for it to compile correctly. e.g. Set NLS_LANG=.WE8ISO8859P15 -15) Using the "Set" command add "ORACLE_USERID=test/[EMAIL PROTECTED]" substituting test with the username/[EMAIL PROTECTED] +16) Using the "Set" command add "ORACLE_USERID=test/[EMAIL PROTECTED]" substituting test with the username/[EMAIL PROTECTED] you wish to run the make test files against. Note: it is not necessary to do this step for the compile and install to work. However: The self-test programs included with Oracle-DBD will mostly fail. -16) Move to the DBD-Oracle directory in the Visual C++ window DOS prompt and enter the following. +17) Move to the DBD-Oracle directory in the Visual C++ window DOS prompt and enter the following. c:\oracle-dbd\>perl Makefile.PL The Makefile should then run and compile Oracle-dbd without reporting any errors. -17) From this DOS prompt enter the following command +18) From this DOS prompt enter the following command c:\oracle-dbd\>nmake The Visual C++ make executable will then build you DBD-execuable. There should be no errors at this point. -18) You can test the compile by either entering +19) You can test the compile by either entering c:\oracle-dbd\>nmake test @@ -116,11 +118,11 @@ the Set ORACLE_USERID = and rerun the tests. iv If you are compiling against 10XE and have skiped steps 12 to 14 try again bu this time carry out these steps -19) You can now install DBD-Oracle into you system by entering the following command from the Visual C++ window dos prompt; +20) You can now install DBD-Oracle into you system by entering the following command from the Visual C++ window dos prompt; c:\oracle-dbd\>nmake install -20) You should now be able to run DBD-Oracle on you system +21) You should now be able to run DBD-Oracle on you system 09/30 2006 from asu <[EMAIL PROTECTED]>
