Question

3
Replies
184
Views
VenkateshKumarR6041 Member since 2015 18 posts
BNY Mellon
Posted: 1 year ago
Last activity: 1 year 4 months ago
Closed
Solved

Stored Procedure Must be declared

We are calling a Stored Procedure to return a unique id value. The SP is called in the browse tab of a Connect-SQL which is called in a RDB-List step in an activity. During run time the SP is getting failed with the below message.

There was a problem getting a list: code: 6550 SQLState: 65000 Message: ORA-06550: line 1, column 7:
PLS-00201: identifier 'SP_BNYM_WORK_ID' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

We checked the grants of the SP which match exactly with the other tables we refer. Please let me know if we have to make any additional configuration.

***Edited by Moderator: Pallavi to update platform capability tags***

Data Integration
Moderation Team has archived post
Share this page LinkedIn