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!