可以(以下是pb帮助中的内容)
If a stored procedure, proc1, is defined as:
CREATE PROCEDURE spm1
(dept varchar2, mgr_name OUT varchar2)
IS lutype varchar2(10);
BEGIN
SELECT manager INTO mgr_name FROM mgr_table
WHERE dept_name = dept;
END;
To declare that procedure for processing within PowerBuilder, you code:
DECLARE dept_proc PROCEDURE FOR
spm1(:dept);
Note that this declaration is a non-executable statement, just like a cursor declaration. Where cursors have an OPEN statement, procedures have an EXECUTE statement.
When the EXECUTE statement executes, the procedure is invoked. The EXECUTE refers to the logical procedure name.
EXECUTE dept_proc;
|