Question

1
Replies
259
Views
ritikap3 Member since 2017 7 posts
Cognizant Technology Solutions India PVT Ltd
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed

how can i pass the a DSS setting in the stored procedure parameter

hi,

i am trying to pass a DSS setting in the parameter of the stored procedure like below

\{ call SP_CAMPAIGN_OFFSETDELETE ( {ASIS:deletetheoldercampaigns} ) \}

i have created "deletetheoldercampaigns" named a DSS and value is 120 but it is giving me error as : There was a problem getting a list: code: 6550 SQLState: 65000 Message: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SP_CAMPAIGN_OFFSETDELETE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

PS: the stored procedure is getting compiled fine from the database

thanks!

DevOps
Moderation Team has archived post
Share this page LinkedIn