EXECUTE

    • 如果创建预备语句的PREPARE语句声明了一些参数，那么传递给EXECUTE语句的必须是一个兼容的参数集，否则就会生成一个错误。

    • name

    • parameter

    2.     CD_DEMO_SK          INTEGER          NOT NULL,
    3.     CD_GENDER           character(16)            ,
    4.     CD_MARITAL_STATUS   character(100)
    5. )
    6. ;
    9. openGauss=# INSERT INTO tpcds.reason VALUES(51, 'AAAAAAAADDAAAAAA', 'reason 51');
    11. --创建表reason_t1。
    13. --为一个INSERT语句创建一个预备语句然后执行它。
    14. openGauss=# PREPARE insert_reason(integer,character(16),character(100)) AS INSERT INTO tpcds.reason_t1 VALUES($1,$2,$3);
    16. openGauss=# EXECUTE insert_reason(52, 'AAAAAAAADDAAAAAA', 'reason 52'); 
    18. openGauss=# EXECUTE insert_reason USING 52, 'AAAAAAAADDAAAAAA', 'reason 52'; 
    20. --删除表reason和reason_t1。
    21. openGauss=# DROP TABLE tpcds.reason;