PL/SQL (MOSC)

MOSC Banner

Package stored procedure with custom datatype parameter not working with DBLink

in PL/SQL (MOSC) 3 commentsAnswered

We have a stored procedure SP1 created in DB1, which contains CUSTOM data type "STRING_ARRAY" as a input parameter.

We created synonym of this stored procedure SP1 on DB2 using a DBLink.

CREATE OR REPLACE SYNONYM SP1 FOR SP1@DBLink;

However, while calling it from spring boot application we are getting an error,connection=HikariProxyConnection@1608742048 wrapping oracle.jdbc.driver.T4CConnection@77f4297d

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

PLS-00306: wrong number or types of arguments in call to 'SP1'

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center