Page 1 of 1

Multiple SQL in Before/Afer sql

Posted: Mon Nov 01, 2010 3:01 pm
by major
Hi all,

I just wanted to know whether we can write multiple sql statements in before/after sql in Oracle OCI stage.

when i try wiht multiple queries it shows an error 'sql statement not properly ended'

Thansk,

Re: Multiple SQL in Before/Afer sql

Posted: Mon Nov 01, 2010 3:36 pm
by ejazsalim
Yes you can separate them with ";"

Posted: Tue Nov 02, 2010 10:11 am
by major
Thanks its working fine.

Just want to share we should not put ; at last statement

Posted: Tue Nov 02, 2010 11:05 am
by Sreenivasulu
Very good trick. Thanks for the updates