execute procedure_name
execute procedure_name(‘in_param’,'in_param’);
execute package_name.procedure_name (….
select myPackage.myFunction(rec_id) from myTable;
select myPackage.myFunction(argValue) from dual;
SQL> @pass2proc
SQL> CREATE OR REPLACE PROCEDURE PASS2PROC(VAL1 IN NUMBER, VAL2 OUT NUMBER)
2 AS
3 BEGIN
4 VAL2 := VAL1*2;
5 END PASS2PROC;
6 /
Procedure created.
SQL> var ret1 number
SQL> exec pass2proc(1,:ret1);
PL/SQL procedure successfully completed.
SQL> print ret1
RET1
----------
2