将参数从一个过程传递到另一个PLSQL

发布于 2025-01-25 08:11:30 字数 463 浏览 4 评论 0原文

我需要将过程“ proc1”的参数“ p_date”传递给过程“ proc2”。可能有必要使用全局变量或其他方式。感谢您的帮助。

CREATE OR REPLACE PACKAGE PKG_TEST  IS 
 
      PROCEDURE proc1 (p_date DATE );
      PROCEDURE proc2;
 
END;
/
 
CREATE OR REPLACE PACKAGE BODY PKG_TEST IS 
 
PROCEDURE proc1 AS
  BEGIN
  INSERT INTO tbl_ins
  SELECT * FROM tbl WHERE dt = p_date;
  END proc1;
  
PROCEDURE proc2 AS
  BEGIN
    DELETE tbl_ins WHERE dt = p_date;
    
   END proc2;
   
 END PKG_TEST;

原文

I need to pass parameter "p_date" of procedure "Proc1" to procedure "Proc2" . It may be necessary to use a global variable or some other way. Thanks for the help.

CREATE OR REPLACE PACKAGE PKG_TEST  IS 
 
      PROCEDURE proc1 (p_date DATE );
      PROCEDURE proc2;
 
END;
/
 
CREATE OR REPLACE PACKAGE BODY PKG_TEST IS 
 
PROCEDURE proc1 AS
  BEGIN
  INSERT INTO tbl_ins
  SELECT * FROM tbl WHERE dt = p_date;
  END proc1;
  
PROCEDURE proc2 AS
  BEGIN
    DELETE tbl_ins WHERE dt = p_date;
    
   END proc2;
   
 END PKG_TEST;

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

心欲静而疯不止 2025-02-01 08:11:31

重新定义您的软件包，以便proc_2还采用日期参数：

CREATE OR REPLACE PACKAGE PKG_TEST  IS 
 
      PROCEDURE proc1 (p_date DATE);
      PROCEDURE proc2 (p_date DATE);
 
END;
/
 
CREATE OR REPLACE PACKAGE BODY PKG_TEST IS 
 
PROCEDURE proc1(p_date DATE) AS
BEGIN
  INSERT INTO tbl_ins
    SELECT * FROM tbl WHERE dt = p_date;
END proc1;
  
PROCEDURE proc2(p_date DATE) AS
BEGIN
  DELETE tbl_ins WHERE dt = p_date;
END proc2;
   
END PKG_TEST;

Redefine your package so that PROC_2 also takes a DATE parameter:

CREATE OR REPLACE PACKAGE PKG_TEST  IS 
 
      PROCEDURE proc1 (p_date DATE);
      PROCEDURE proc2 (p_date DATE);
 
END;
/
 
CREATE OR REPLACE PACKAGE BODY PKG_TEST IS 
 
PROCEDURE proc1(p_date DATE) AS
BEGIN
  INSERT INTO tbl_ins
    SELECT * FROM tbl WHERE dt = p_date;
END proc1;
  
PROCEDURE proc2(p_date DATE) AS
BEGIN
  DELETE tbl_ins WHERE dt = p_date;
END proc2;
   
END PKG_TEST;

回复收藏 0 原文

許願樹丅啲祈禱 2025-02-01 08:11:31

制作包装没有真正的原因。

就您而proc1的参数，您可以这样做：

CREATE OR REPLACE PACKAGE PKG_TEST  IS 
    PROCEDURE proc1 (p_date DATE ); 
END;
/
 
CREATE OR REPLACE PACKAGE BODY PKG_TEST IS 
 
  PROCEDURE proc1 IS
    PROCEDURE proc2 IS
    BEGIN -- proc2 is a local procedure of proc1
      DELETE tbl_ins WHERE dt = p_date;
    END proc2;
  BEGIN
    INSERT INTO tbl_ins
    SELECT * FROM tbl WHERE dt = p_date;
    PROC2();
  END proc1;
   
END PKG_TEST;
/

It's not good idea to make packages "stateful" without a real reason.

In your case, if you are going to call proc2 from proc1 (otherwise, I don't know why you may want to hard code it to the same value as your input parameter of proc1), you can do like this:

CREATE OR REPLACE PACKAGE PKG_TEST  IS 
    PROCEDURE proc1 (p_date DATE ); 
END;
/
 
CREATE OR REPLACE PACKAGE BODY PKG_TEST IS 
 
  PROCEDURE proc1 IS
    PROCEDURE proc2 IS
    BEGIN -- proc2 is a local procedure of proc1
      DELETE tbl_ins WHERE dt = p_date;
    END proc2;
  BEGIN
    INSERT INTO tbl_ins
    SELECT * FROM tbl WHERE dt = p_date;
    PROC2();
  END proc1;
   
END PKG_TEST;
/

回复收藏 0 原文

~没有更多了~