Posted on 2016-11-14
I have an Oracle stored procedure which accepts 3 variables of type VARCHAR. Short example given below.
If I want to execute this stored procedure from the command line, how would I do it? I tried something like this, but it
does not work : EXECUTE IMMEDIATE PortalForClient USING var1, var2, var3
I can do this quite easily in sql server query analyzer. However Oracle is quite different, so I would appreciate some help from an Oracle expert.
CREATE OR REPLACE PROCEDURE "PortalForClient"
var1 IN VARCHAR := NULL,
var2 IN VARCHAR := NULL,
var3 IN OUT CHAR