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.
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.
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);
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms