ERROR : Oracle LONG fields reformatted in PeopleTools 8.16 Query

[MJRBIM]

We are using the PeopleTools 8.16 Query tool to create queries from an Oracle datasource.

In the Oracle datasource we have fields that have a defined format of LONG.

However, when we look at the query in the PeopleTools 8.16 Query tool - the field format is defined as either a Char999 or a Char with no defined field length.

All other field-formats in in the PeopleTools 8.16 Query tool are displayed exactly as they appear in Oracle, but the LONG format is NOT displaying correctly.

Has anyone seen this before? Any suggestions would be welcome.

Thanks in advance...

 

[chrish47]

Hi,

We are on PeopleSoft 7.52, and I have seen this same situation (we are on Oracle also). Unfortunately we haven't come up with a way to solve this problem. If you do find any soulution, I would appreaicate it if you would contact me or post it to this group.

PO comments are stored in a field called COMMENTS2000 that is 2000 characters (a long in Oracle), when this field is viewed in a query, only the first 999 characters are shown, which is enough for many of the PO Comments, but due to the way we are using this field, changes to the po may not be shown because they are in the second half of the comments field.

I have tried to work with our technical people to find the SQL syntax to extract the field in pieces (ie. create 1 query expression which shows char 1-999, and another that shows 1000-1999, and forget the last 1), but all attempts at this in query expressions have resulted in various errors.

If you have any luck at this, I would appreciate hearing about it.

Thanks
Chris Huss
Central Washington University

 

[MJRBIM]

Our solution was to use an expression, but only for the first 999...nothing for the backend.

We set the Expression Type of the Oracle LONG field to Character, and Length to 999.

You might be able to do something with Oracle SQL - to strip the field into sections.