Start with program decodePC.java with comments from Nov 2007.
For example, within method stagePeopleCode comment out the Oracle code used for reading PROGTXT when declared as LONG RAW (Oracle begin, Oracle end) and uncomment the MySQL code which was written for datatype BLOB (MySQL begin, MySQL end), ignore the log entries.
This should work. Notice that David Price originally used a temporary table to copy the data from a table with PROGTXT declared as LONG RAW to one with it declared as BLOB. This allowed him to then use the Oracle version 9 BLOB functions (UTL_...).
Replacing LONG RAW Oracle code with BLOB MySQL code should work
Hi,
Start with program decodePC.java with comments from Nov 2007.
For example, within method stagePeopleCode comment out the Oracle code used for reading PROGTXT when declared as LONG RAW (Oracle begin, Oracle end) and uncomment the MySQL code which was written for datatype BLOB (MySQL begin, MySQL end), ignore the log entries.
This should work. Notice that David Price originally used a temporary table to copy the data from a table with PROGTXT declared as LONG RAW to one with it declared as BLOB. This allowed him to then use the Oracle version 9 BLOB functions (UTL_...).
Please post errors if you run into problems.
Regards