Question about Confluence SQL plugin

[vaishali bansal]

I am running a stored procedure on confluence using Bob Swift's SQL pluing -

IF OBJECT_ID('dbo.test_Run_For_a_Day') IS NOT NULL

BEGIN

DROP TABLE dbo.test_Run_For_a_Day

END

GO

However I hit the following error each time. This command works fine with in the SQL management studio -

Error rendering macro 'sql' : java.sql.SQLException: Incorrect syntax near 'GO'

[Bob Swift OSS (Bob Swift Atlassian Apps)]

Answered here.

[Jonas Andersson]

Hi Bob,

That link is dead. Is it possible to run stored procedures via the SQL plugin?

Kind regards

Jonas