RDBPROD: Forms 10g R2 Does Not Work With Oracle Rdb (Doc ID 436342.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Forms - Version 10.1.2.0.2 to 10.1.2.2.0 [Release Oracle10g to 10.1.2.2]
Oracle SQL/Services for Rdb on OpenVMS - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

When compiling a form that contains PL/SQL against an Rdb database via a SQL/Services OCI service you may get errors like these:

ORA-904: Invalid column name %SQL-F-RTNNOTDEF, function or procedure RTRIM is not defined

or

ORA-942: table or view does not exist %SQL-F-RELNOTDEF, Table DUAL" is not defined in database or schema

Changes

The same forms compile using Forms 9i against Rdb, but not with 10g R2.

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