Hi,

i got this resolved. The problem was due to an invalid statement in the stored procedure...the error did not appear when the stored procedure was compiled..but when called from a java program

---------------------------------------------------------------------

The code:

CREATE PROC myProcedure @tableA_name varchar(30),@tableA_column varchar(30)

AS

BEGIN

DECLARE @param1 varchar(50),

@param2 varchar(50),

@param3 varchar(50),

@functionString varchar(1000),

@updateQuery varchar(1000)

SET @updateQuery = 'update '+@tableA_name+' set '

SET @param1 = 'tableB';

SET @param2 = 'STATE';

SET @param3 = '';

-- this EXEC statement caused the error

EXEC ('insert into tableC(tab_Name,colm_Name) values ('''+@tablename+''','''+@col+''')');

-- the corrected statement is

-- insert into tableC(tab_Name,colm_Name) values(@tablename,@col)

SET @functionString = '(myFunction('''+@param1+''','''+@param2+''','''+@param3+''')),';

SET @updateQuery = @updateQuery + @tableA_column +'='+@functionString;

EXECUTE(@updateQueryFinal);

END

--------------------------------------------------------------------

It was my mistake of not providing the procedure code too...:hehe: