Saw your code up on passportgeek that allows you to decode PeopleCode.
I got it running on my PT8.43 environment (bit of work as I am using jdbc:oracle:thin, but it doesn't work in PT8.48. (The code fails to extract the string from the progtext field)
I'm pretty sure the reason is that we have built the PS Portal 8.9 / PT8.48 environment on Oracle 10.2.0.3.0, and now PROGTEXT is stored as a BLOB, whereas in Ora9 it's stored as a LONG RAW.
The line that isn't working is somewhere around
OOB[row_cnt] = resultset.getString("progtxt");
I tried to merge the MySQL codeline as that looked BLOB related, but I started getting confused as to how on earth decoding into UTF-16LE etc is handled when converting from a BLOB to a string. It's just that
little bit out of my comfort zone, so I've backed off.
Anyway, good work on posting the code and I'll let you know if I keep playing with it.
The code fails to extract the string from the PROGTEXT field
Saw your code up on passportgeek that allows you to decode PeopleCode.
I got it running on my PT8.43 environment (bit of work as I am using jdbc:oracle:thin, but it doesn't work in PT8.48. (The code fails to extract the string from the progtext field)
I'm pretty sure the reason is that we have built the PS Portal 8.9 / PT8.48 environment on Oracle 10.2.0.3.0, and now PROGTEXT is stored as a BLOB, whereas in Ora9 it's stored as a LONG RAW.
The line that isn't working is somewhere around
OOB[row_cnt] = resultset.getString("progtxt");
I tried to merge the MySQL codeline as that looked BLOB related, but I started getting confused as to how on earth decoding into UTF-16LE etc is handled when converting from a BLOB to a string. It's just that
little bit out of my comfort zone, so I've backed off.
Anyway, good work on posting the code and I'll let you know if I keep playing with it.