(how to handle) Oracle sqlplus & Multiple Return Paramters
Posted on 2001-08-27
Ok, I am struggling with executing the PL/SQL proc that returns not one but TWO return parameters: see below.. It is a simple syntax problem, but I havent yet found one reference to handling 'multiple' return parameters from a proc...
The PACKAGE (or proc that needs to be called has 2 OUT params, 2 IN params)
errbuf OUT VARCHAR2,
retcode OUT NUMBER,
p_org_id IN NUMBER,
element IN VARCHAR2)
So I try to execute following SQLPLUS:
variable errbuf varchar2
variable retcode number
execute :errbuf :retcode := apps.mrp_i2_erp.populate_load (errbuf,retcode,3,'set_start_date');
Oracle8 Enterprise Edition Release 184.108.40.206.0 - Production
PL/SQL Release 220.127.116.11.0 - Production
begin :errbuf :retcode := apps.mrp_i2_erp.populate_load(errbuf,retcode,3,'set_start_date'); end;
ERROR at line 1:ORA-06550: line 1, column 15:
PLS-00103: Encountered the symbol "" when expecting one of the following: := . ( @ % ; indicator
The symbol ";" was substituted for "" to continue.
There is something wrong with the output param binding assignment in the execute statement I tried all different ways to execute the procedure to no avail, the manuals/google searches do not explain anything about multiple return parameters, one return parameter is easy..