[CraigPardey]

Hi,

The SQL editor is now unable to compile stored procedures for Sybase that have dynamic temporary tables in them. It fails with a syntax error.

Try compiling this:

create procedure fire.temp_proc
as
begin

create table #temp(id int)

end

Craig

[CraigPardey]

you might want to remove the ‘fire.’ prefix … that is a local user id.

[Riyad Kalla]

Can you please post all the information we request in the [URL=http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-393.html]Posting Guidelines[/URL] thread at the top of this forum? That will give us some context so that we can determine if this is an installation issue, a configuration problem, or a bug. Thanks.

[Author]

Posts