Error while executing procedure

Database
Enthusiast

Error while executing procedure

Hi all,

I am getting the following error while exectuing the procedure .

Procedure:
----------------
Replace Procedure CFSysSPDev.AutomatedPassthruValidation(In str_targettable varchar(2000),Out int_recorddiff integer)
BEGIN
Declare v_strsql varchar(6000);
Set v_strsql = 'SELECT * FROM'|| str_targettable ;
SELECT COUNT(1) INTO :int_recorddiff FROM (: v_strsql ) as a ;
END;

Error:
--------------
SPL1027:E(L6),Missing/Invalid SQL statment 'E(3707): Syntax error,expected something like a name or unicode delimited identifier or 'SELECT' keyword or '(' between '(' and ':' .'.