my proc is as:
Code:
CREATE OR REPLACE PROCEDURE TEST_BUILDINGCODE_PROC (IN v_AppId_Ver INTEGER) BEGIN DECLARE v_ObjId,v_LayerName,v_TableName,v_ColumnName varchar(30); DECLARE v_CodeNo,v_DataCount integer; DECLARE v_Statement,v_Schema,v_Counter varchar(200);