Unanswered question

What are the values for parameter and parameter signature in sp-execute?

My stored procedure looks like this
"begin packagename.procname; end;"
how to pass values for this stored procedure?
When I use sp-execute action it is asking for parameter value and parameter signature, But the procedure has no parameters.
How can we pass values if there are no parameters but only variables in the procedure?

Harshitha B.
Harshitha B.

Harshitha B.

Level
0
2 / 100
points

No answers