```
create or replace
PROCEDURE TEST3(CREATED_BY_IN IN VARCHAR2,SRC_NAME IN VARCHAR2,TGT_NAME IN VARCHAR2,OUTPUT OUT VARCHAR2)
IS
CHECK_STATUS INTEGER;
SRCSQL VARCHAR(1000);

BEGIN

 SRCSQL:= 'INSERT INTO TBLCNT SELECT '||''''||CREATED_BY_IN||''''||','|| ' COUNT(*),' ||''''||SRC_NAME||''''||' FROM  '||SRC_NAME ;

EXECUTE IMMEDIATE SRCSQL USING CREATED_BY_IN,SRC_NAME;

OUTPUT:=SRCSQL;
END;

```

Iam getting the error stating 'Bind variable does not exist'.
Can anyone please help me with this