You would need a transmission designed to handle the torque of a 350 small-block Chevy engine. This usually involves a much more substantial transmission, such as a TH350, TH700R4, 4L60E, 700R4, or a T5 manual transmission (or stronger variants of those), depending on the year of the Camaro and the specifics of the 350 engine build. The bellhousing will also likely need to be changed to mate the engine and transmission correctly.