My Oracle Support Banner

PL/SQL Package Created In 10g From Java Application Is Invalid due to CR character (Doc ID 1399110.1)

Last updated on JULY 22, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
JDBC - Version 10.2.0.5 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms


A Java JDBC application reads a text file containing PL/SQL code and submits it to a database version 10g ( 10.2.0.5 database tested).  The PL/SQL package does get created however it contains a compilation error.
The same package compiles fine when the same Java program  creates it on the 11g database. ( 11.1 and 11.2 databases tested).
This is not specific to the JDBC driver used by the Java program.

Example of the SQL source code text file pack1.sql:



There are no compilation errors on the 11g databases.

The complete testcase is available in testcase.zip

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.