My Oracle Support Banner

CANNOT INVOKE STORED PROCEDURE WITH SYS PRIVILEGES AT ORACLE.JPUB.REFLECT.CLIENT.INVOKE (Doc ID 1073389.1)

Last updated on JULY 23, 2021

Applies to:

JPublisher - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

A JDBC client testcase application invokes a Java class that has been uploaded into a database version 10.2.0.4 using the jpub.reflect.Client.invoke() method.

The purpose of the jpub.reflect.Client.invoke() method is to allow a Java client program to directly invoke Java code that has been uploaded to the database without need for publishing an interface for it such as creating a Java Stored Procedure.


This call fails with the error:

java.sql.SQLException: Cannot invoke a stored procedure with SYS privileges


The JDBC client is not trying to log in as SYS but rather using another database user

example:

Java class to be uploaded to the database:

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
References


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