PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Peoplecode SQL not as expected

edited Dec 13, 2022 10:16PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

I have created this peoplecode method classDate(), in order to append a timestamp audit column from PSAUDIT

method getInfo2
  Local string &writeString;
  Local string &retTerm, &retDept, &retNum, &retSec, &retCourseTitle, &retInstructorName, &retContentType, &retISBN, &retTitle, &retEdition, &retAuthor, &retPublisher, &retStartDate, &retEndDate, &retCensusDate, &retClassCapacity, &retCourseID;
  Local SQL &sql = GetSQL(SQL.LC_BOOKLIST_SQL);
  
  While &sql.Fetch(&retTerm, &retDept, &retNum, &retSec, &retCourseTitle, &retInstructorName, &retContentType, &retISBN, &retTitle, &retEdition, &retAuthor, &retPublisher, &retStartDate, &retEndDate, &retCensusDate, &retClassCapacity, &retCourseID)
    
   %This.STRM = &retTerm;
   %This.CourseID = &retCourseID;
   %This.Section = &retSec;
   %This.classDate();
    
   &writeString = &retTerm | "," | &retDept | "," | &retNum | "," | &retSec | "," | &retCourseTitle | "," | &retInstructorName | "," | &retContentType | "," | &retISBN | "," | &retTitle | "," | &retEdition | "," | &retAuthor | "," | &retPublisher | "," | &retStartDate |

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center