Question

1
Replies
284
Views
Close popover
ritika pandey (ritikap3)
Infosys
ritika pandey
Infosys
IN
ritikap3 Member since 2017 11 posts
Infosys
Posted: September 17, 2018
Last activity: September 17, 2018
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,
Close popover 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.