That's a bug in MBuilder that's resulted from the Oracle code being cut-and-pasted from the Postgres code.
Arek/Syed - you'll have to go through OracleDialect and completely remove any lines which output 'set....' to the SQL buffer. 2008/6/16 Renato Golin <[EMAIL PROTECTED]>: > > Hi, > > Just got another Oracle error: > > SP2-0735: unknown SET option beginning "search_pat..." > > for the query: > > set search_path=RENATO1,pg_catalog; > > I have no idea how to set variables on Oracle but also I didn't find any use > of 'search_path' within the generated SQL so I guess this is harmless for > the time being. > > --renato > > -- > Reclaim your digital rights, eliminate DRM, learn more at > http://www.defectivebydesign.org/what_is_drm >
