* Automatic: The most likely automatic transmission would be a 4L60E four-speed automatic.
* Manual: Several manual transmissions were available, most likely a BorgWarner T5 five-speed manual. There might have been others depending on the specific options.
To know for sure what transmission is in a *specific* 1994 Camaro, you need to check the vehicle's documentation (owner's manual, build sheet if available) or look at the transmission itself (the case usually has identifying numbers).