..小程小小小..

CREATE PROCEDURE [dbo].[Common] @strTable varchar(30),--表名@strFields varchar(300),--检索的字段@strSortField varchar(30),--排序的字段@PageIndex int =1, --页码@PgSize int,--每页大小@doCount bit=0,

create or replace procedure proc_xop_test(v_supplier_id in number, v_updatesupplier_id in number) as V_ERRCODE NUMBER(20); V_ERRMSG VARCHAR2(200);

CREATE OR REPLACE PROCEDURE proc_xop_test(v_supplier_id in number,updatesupplier_id in number) as V_SQL VARCHAR2(4000); V_ERRCODE NUMBER(20); V_ERRMSG VARCHAR2(200); v_GOODS_ID varcha