Re: [mart-dev] Another Oracle glitch

2008-06-16 Thread Richard Holland
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

Re: [mart-dev] Another Oracle glitch

2008-06-16 Thread Arek Kasprzyk
On 16-Jun-08, at 11:52 AM, Renato Golin wrote: Hi, Just got another Oracle error: SP2-0735: unknown SET option beginning search_pat... for the query: set search_path=RENATO1,pg_catalog; ^^ looks like posgres syntax not oracle a. I have no idea how to set variables on Oracle but also