64-bit LispWorks now supports Oracle 10.2.0.4 on Intel Mac OS X.
At the time of writing there no 64-bit PowerPC Oracle instant client library is available, therefore 64-bit LispWorks cannot support Oracle on PowerPC Macintoshes.
LispWorks Release Notes and Installation Guide - 21 Dec 2009