[Pansophy] Entry made in Pansophy Logbook by BOOKWALT

BOOKWALT at jlab.org BOOKWALT at jlab.org
Wed Jul 27 09:21:11 EDT 2011


Pansophy Logbook Entry
         Keywords: Error with P1 travelers and Oracle 10g
         Date:	27-Jul-2011
         Text:	P1 travelers were showing errors of arrays not being complete. This is due to moving to Oracle 10g. If no value is returned for a field the array would still denote it's existence, but with 10g NULL is returned and therefore the array was not being correctly created. This causes array lengths to be uneven and thus cause display errors for travelers. ORGetSerialNoVariable.cfm a custom tag had this problem. I have modified it to put " " where nulls use to exist. This has corrected the problem. 


More information about the Pansophy mailing list