Calling PL/SQL Web Services Created Using JDeveloper, Got the Error "PLS-00181: unsupported preprocessor directive" (Doc ID 1123203.1)

Last updated on FEBRUARY 13, 2024

Applies to:

Symptoms

When calling web services created using JDeveloper 11.1.1.2.0 from a PL/SQL package with Numeric Types = Objectjdbc, got the following error:

java.sql.SQLException: ORA-06550: line 1, column 59:

PLS-00181: unsupported preprocessor directive '$F_BOOLEAN_'

 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3467)

at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:3879)

This issue also occurs with JDeveloper 10.1.3.4.

Changes

Cause

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