'SQL error in Exec (2,280) SSR_STUDENT_RECORDS.SR_ClassData.ClassSearch.OnExecute' When Searching for a Class with an Apostrophe in the Subject

(Doc ID 2258376.1)

Last updated on APRIL 24, 2017

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.


On : 9 version, Student Records Class Search

SQL error was displayed in Class Search if user input a apostrophe in the field Course Subject.


"SQL error in Exec (2,280)
SSR_STUDENT_RECORDS.SR_ClassData.ClassSearch.OnExecute Name:RunClass Search
PCPC: 23511 Statement: 405
Called from: CLASS_SRCH_WRK2.SSR_PB_CLASS_SRCH.FieldChange Statement: 85

During the execution of SQL, an error occurrred in the Exec Subroutine. The
preceding message should have described the SQL being executed."

The issue can be reproduced at will with the following steps:
1. Navigate to Self Service > Class Search/Browse Catalog > Class Search.
2. In the subject field, append an apostrophe to the end.
3. Search and the error will occur.

The issue has the following business impact:
Due to this issue, users unable to complete class search in some cases.


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