[pdohara]

I have a number of SQL scripts of the form:

declare @GROUP_XREF varchar(30)
select @GROUP_XREF = ‘feedtest’;
select GROUP_ID from gr_group where XREF = @GROUP_XREF;

This does not work in the MyEclipse Database Explorer. I assume this is because MyEclipse is parsing the file and executing the statements in seperate connections, or something like that. Is there a setting that can be changed to allow scripts like that to work? There are other tools where multi-line scripting works, but none of them are offered as an Eclipse plugin.

Thanks for your time on this

Pat O

[Riyad Kalla]

I don’t think this is supported, but I’m checking on it.

[support-jeff]

Have you tried selecting each statement and executing individually? I know it’s a pain for scripting work, but that should work.

Because the script has multiple resultsets, it won’t work the way DE is designed. I will put in an RFE though.

[Author]

Posts