My Oracle Support Banner

E-PC: In PT 8.58, Fetching a LONG Column Into a Peoplecode Variable Causes the Application Server to Crash (Doc ID 2756106.1)

Last updated on APRIL 04, 2025

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.

Symptoms

Using a SQL object and Fetch method, to select a LONG column into a PeopleCode variable, causes the Application Server to crash. If the column being selected is not of type LONG, the code executes just fine.

In the example below, column high_value, in table dba_tab_subpartitions, is of type LONG. The SQL object selects that column and the Fetch method loads its value into PeopleCode variable &highvalue.

Example:



 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.