No, a V6 engine from a 1994 Camaro will almost certainly
not fit directly into a 1998 Camaro transmission. While both are Camaros, the transmission and engine mounts changed over the years, and even within a single model year there were different engine and transmission combinations.
The bolt patterns, bellhousing size and shape, and overall dimensions are likely incompatible. You'd need significant modifications, possibly including a custom adapter plate, to even attempt such a swap. It's a very complex and unlikely to be successful project for a home mechanic.