Execute multiple SQL statements at once?

From within my VC app (I'm using OLE DB via ADO) I try to execute two statements, but Oracle doesn't like the semicolon delimeter. Is there any way to send two statements at once and have Oracle see them as two statements rather than one?

e.g.
CREATE TABLE X(Y INT);
GRANT SELECT, REFERENCES ON X TO PUBLIC This returns an error "Invalid Character" and if I remove the semicolon I get an error that the statement wasn't properly ended. So how do you seperate them, or can you? I'd really rather not parse everything and send individual statements.

Thanks,
Mark
mark.bird_at_intel.com Received on Wed Sep 16 1998 - 12:35:10 CDT