create procedure TradeOrderFrame01(in acct_id decimal(11),out num_found int) begin declare brId decimal(11); declare cuId decimal(11); select CA_NAME as acct_name,CA_TAX_ST as tax_status ,(CA_B_ID into brId),(CA_C_ID into cuId) from CUSTOMER_ACCOUNT where CA_ID = acct_id; end
为什么这里的into语句会报错呢,提示应该期望看到分号。为什么啊?
解决方案
20
应该是语法错误吧 应该是CA_B_ID, CA_C_ID into brId,cuId 这种格式