FRM-41214 Unable to Run Report (run_report_object) when Parameter has a Single or Double Quote (Doc ID 1538202.1)

Last updated on MARCH 18, 2013

Applies to:

Oracle Forms - Version 11.1.1.6.0 and later
Oracle Reports Developer - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

When passing a parameter value with a single quote such as h'ello an immediate FRM-41214 occurs and the job submission does not appear in showjobs or rwEng-n_diagnostic.log/rwservlet_diagnostic.log.

The problem also occurs when calling a report directly using rwserlvet.  For example ->

http://machine:port/reports/rwservlet?report=testquote.rdf&server=servname&userid=scott/tiger@db&desformat=htmlcss&destype=cache&p_test=h'ello

In this case, you will immediately receive ->

 Note that the problem only occurs when an odd number of single or double quotes is contained in the parameter value.

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