Question

3
Replies
426
Views
Venkatesh Kumar Rajendran (VenkateshKumarR6041)
BNY Mellon

BNY Mellon
IN
VenkateshKumarR6041 Member since 2015 23 posts
BNY Mellon
Posted: April 30, 2019
Last activity: May 2, 2019
Posted: 30 Apr 2019 1:48 EDT
Last activity: 2 May 2019 22:08 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.