如何在Oracle的其他程序中调用程序，Sql Developer？

Question

CREATE OR REPLACE PROCEDURE ShowShips3Task(
     p_Register IN ship.registry_country%TYPE, 
     o_name OUT ship.ship_name%TYPE, 
     o_capitan OUT ship.captain_name%TYPE) 
IS 
    procedure showshipsDisp(
    o_cap out Ship.captain_name%type, 
    o_dis out Ship.displacement%type) 
    is 
    begin 
    Select Captain_name, Displacement 
    into o_cap, o_dis 
    from Ship Where Ship_name = 'Avrora'; 
    end; 

BEGIN 

    SELECT Ship_name , Captain_Name 
    INTO o_name, o_capitan 
    from Ship WHERE registry_country LIKE p_register || '%'; 

END; 

如何执行一个程序在同一时间内的另一个程序？

如何创建多值参数，意味着第二个程序里面依赖于第一个程序的参数？

Answer 1

在问题嵌套过程的例子中，只声明但从未调用。要运行嵌套过程的调用必须BEGIN和END语句之间存在：

BEGIN 

    SELECT Ship_name , Captain_Name 
    INTO o_name, o_capitan 
    from Ship WHERE registry_country LIKE p_register || '%'; 

    showshipsDisp(o_cap => ? 
       ,o_dis => ?); 

END; 

问号应该通过适当的变量来代替。