PROC里怎么调用存储过程啊？很简单的，高分送

Question

这是Oracle么？没这么玩过

Answer 1

晕，PROC啊。我想知道程序里怎么调存储过程

Answer 2

void sms()
{
        EXEC SQL BEGIN DECLARE SECTION;
        HSMSDCUST        psmsdcust;
        CHAR        i_BANK[21];
        EXEC SQL END DECLARE SECTION;
        
        EXEC SQL EXECUTE
                BEGIN
                        ADD_USER(:psmsdcust->cust_id,
                                         :psmsdcust->name,
                                         :psmsdcust->phone,
                                         :psmsdcust->addr.
                                         :psmsdcust->prior,
                                         :psmsdcust->msgnum,
                                         :i_BANK,
                                         :psmsdcust->memo,
                                         :RetCode);
                  END;
        END-EXEC;}

Answer 3

楼上的兄台是说把END_EXEC改成END-EXEC么？改了又出这种错了        EXEC SQL EXECUTE
..........1
PCC-S-02345, 在使用嵌入式 PL/SQL 块时,必须指定 SQLCHECK=SEMANTICS

Answer 4

//PROC调用过程pre_trouble_list_112
EXEC SQL EXECUTE
begin
pre_trouble_list_112(:result_status, \
:process_num, \
:err_code,\
:err_msg
);
end;
END-EXEC;

Answer 5

和续行符无关吧？我是在VC里编译的，不知道他说的SQLCHECK=SEMANTICS这个参数在哪指定

Answer 6

void sms()
{
        EXEC SQL BEGIN DECLARE SECTION;
        HSMSDCUST        psmsdcust;
        CHAR        i_BANK[21];
        EXEC SQL END DECLARE SECTION;
        
        EXEC SQL EXECUTE;  //这里错误，EXEC SQL EXECUTE后面不应该有; 吧
                BEGIN
                        ADD_USER(:psmsdcust->cust_id,
                                         :psmsdcust->name,
                                         :psmsdcust->phone,
                                         :psmsdcust->addr.
                                         :psmsdcust->prior,
                                         :psmsdcust->msgnum,
                                         :i_BANK,
                                         :psmsdcust->memo,
                                         :RetCode)
                  END;
        END_EXEC;}

Answer 7

呵呵，楼上的，是没有那个分号，但不是这个问题，我想应该是写成END-EXEC，但是我不知道后来报错说 EXEC SQL EXECUTE
..........1
PCC-S-02345, 在使用嵌入式 PL/SQL 块时,必须指定 SQLCHECK=SEMANTICS
这个参数具体在哪指定