'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.

Symptoms

On : 9 version, Student Records Class Search

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

ERROR
-----------------------

"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."



STEPS
-----------------------
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.

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

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