sql server - Getting error Incorrect syntax near the keyword 'BEGIN' when executing stored procedure -

so, i'm new ms sql (have been using oracle last 5-7 years) , should straight forward thing do, reckon i'm missing simple. (i've tried following examples here: http://technet.microsoft.com/en-us/library/ms190669(v=sql.105).aspx)

so, create following stored procedure query table (this simple , pointless procedure can't proceed more complex procedure until resolve problem)

create procedure sp_gettransactions select * mytransactions; 

i try execute procedure

execute dbo.sp_gettransactions 

(i've tried without dbo. , same error)

this gives me helpful error incorrect syntax near keyword 'begin'.

now, maybe i'm crazy don't see begin statement anywhere in procedure (i've tried adding 1 no avail).

can give me pointers here? thanks

actually, problem turns out client using. executing sql scripts using oracle's sqldeveloper mssql jtds driver. seems driver works fine part, when comes running stored procedures there's bug. guess execute statement isn't parsed plugin when being set server