从过程中调用表函数（PL SQL）

debugcn 发表于 Dev

用户名

我在调用从我的程序返回表的函数时遇到了很大的麻烦。我相信我的声明有误，因此无法编译。这是我的代码。.开发人员用红色在SELECT“ D_ID”和表“（IREL_FN（X））”下加下划线；。这是我的代码。

CREATE OR replace PROCEDURE Irrelevant_skata (x NUMBER)
AS
  d_id T_ID_TABLE;
BEGIN
  DECLARE
  TYPE yo_table
IS
  TABLE OF YO_TABLE;
  YO_TABLE "(IREL_FN (X))"%TYPE;
  id                 NUMBER;
BEGIN
  SELECT "D_ID"
  INTO   yo_table
  FROM   TABLE "(IREL_FN (X))";

EXCEPTION
WHEN no_data_found THEN
  dbms_output.Put_line('NO DATA FOUND');
END;
END irrelevant_skata;

和功能

CREATE OR replace FUNCTION Irel_fn (x IN NUMBER)
RETURN T_ID_TABLE
AS
  id T_ID_TABLE;
BEGIN
    BEGIN
        SELECT Cast(MULTISET(SELECT "id"
                             FROM   "somethingcopy"
                             WHERE  "kati" IN (SELECT "auto"
                                               FROM   "ekeino"
                                               WHERE  "id" = x)) AS T_ID_TABLE)
        INTO   id
        FROM   dual;

        RETURN id;
    EXCEPTION
        WHEN no_data_found THEN
          dbms_output.Put_line('null');
    END;
END irel_fn;

给IT

create or replace
PROCEDURE IRRELEVANT_SKATA (INSID IN NUMBER) AS ID T_ID_TABLE ;
BEGIN
      DECLARE
          YO_TABLE T_ID_TABLE;
      BEGIN
          select ID 
          into YO_TABLE
          from table(IREL_FN(INSID));
      EXCEPTION
          WHEN NO_DATA_FOUND THEN dbms_output.put_line('NO DATA FOUND');      
      END;
END IRRELEVANT_TWEET;



<-----------------------------FUNCTION---------------------------------->

create or replace
FUNCTION IREL_FN ( D_ID IN NUMBER ) RETURN T_ID_TABLE AS 
ID T_ID_TABLE;
BEGIN      
BEGIN
    SELECT CAST(
    MULTISET(
    SELECT "Id"
    FROM "SOMETHINGCOPY"
    WHERE "KATI" = (SELECT "EKEINO" FROM "AUTO" WHERE "Id"=D_ID)
    INTO ID
    FROM DUAL;
return ID;
EXCEPTION
  WHEN NO_DATA_FOUND THEN dbms_output.put_line('null');    
END;

END IREL_FN;