Use JDBC within Oracle client version 11.1 against an Oracle 10gR2 database being used for the PeopleSoft application. Copy decodePC.java onto a PC in directory c:\decodePC.
Create decodePC_build.bat to compile program decodePC.java into decodePC.class.
Create decodePC.bat to run decodePC.class.
Run the bat files from a Windows command prompt. decodePC_build.bat contains 2 statements:
pushd c:\decodePC
c:\oracle\ora111\jdk\bin\javac -classpath .;c:\oracle\ora111\jdbc\lib\ojdbc5.jar decodePC.java decodePC.bat contains 2 statements:
c:\oracle\ora111\jdk\bin\java -Xmx350m -classpath .;c:\oracle\ora111\jdbc\lib\ojdbc5.jar decodePC Oracle client version determined by running: Start > All Programs > Oracle > Application Development > sqlplus.
An Oracle 10gR2 database is most likely using data type Blob to store progtxt.
Example from Windows XP with Oracle JDBC
Use JDBC within Oracle client version 11.1 against an Oracle 10gR2 database being used for the PeopleSoft application.
Copy decodePC.java onto a PC in directory c:\decodePC.
Create decodePC_build.bat to compile program decodePC.java into decodePC.class.
Create decodePC.bat to run decodePC.class.
Run the bat files from a Windows command prompt.
decodePC_build.bat contains 2 statements:
pushd c:\decodePC
c:\oracle\ora111\jdk\bin\javac -classpath .;c:\oracle\ora111\jdbc\lib\ojdbc5.jar decodePC.java
decodePC.bat contains 2 statements:
pushd c:\decodePC
c:\oracle\ora111\jdk\bin\java -Xmx350m -classpath .;c:\oracle\ora111\jdbc\lib\ojdbc5.jar decodePC
Oracle client version determined by running: Start > All Programs > Oracle > Application Development > sqlplus.
An Oracle 10gR2 database is most likely using data type Blob to store progtxt.