E-PC: %NoUppercase Does Not Work With CreateSQL (Doc ID 1904641.1)

Last updated on NOVEMBER 30, 2015

Applies to:

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

Symptoms

The %NoUppercase meta-SQL statement does not work with the SQL class on any multi-row select statements.

Replicated the issue on 8.49.33 and 8.53.13.

Replication steps:


1. Add the following code into CHange_PWD_BTN.SavePreChange event.

--------------
Local SQL &sqlFIELDSinREC1;
Local string &name1;
Local number &age1;

&sqlFIELDSinREC1 = CreateSQL("%NoUppercase select name,age from PS_TEST");

While &sqlFIELDSinREC1.Fetch(&name1, &age1)
   
   SQLExec("insert into PS_TEST2 values(:1,:2)", &name1, &age1);
   
End-While;
----------------

2. Save the change.
3. Open Change Password page from PIA.
4. Change the password.
5. Error message received:


SQL.Fetch: object isn't open on a select. (2,288) DERIVED_PSWD.CHANGE_PWD_BTN.SavePreChange  PCPC:227  Statement:2
A fetch can only be done on an SQL object that is open on a select. Either the object is closed, or the statement is not a select.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms