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

Last updated on NOVEMBER 01, 2016

Applies to:

Web Services - Version 10.1.3.4.0 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Oct-2013***

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.

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