Re: case inside a select to deal wit it??

From: Jim Smith <>
Date: Fri, 6 Jul 2007 21:01:47 +0100
Message-ID: <>

In message <>, Shishir <> writes
>no it dint work before i modified also..
>basically what i want to achieve is to check the status of IsActive
>column which holds binary 0 or 1..i expect this procedute to display
>"active" when its one and inactive if 0..tats why case statement has
>been used..

As others have pointed out the problem is with a semicolon in the middle of a sql statement.
If the migration workbench generated this code then you should report it as a bug, either in metalink or in the migration workbench forum.

Jim Smith
Ponder Stibbons Limited <>
RSS <>
Received on Fri Jul 06 2007 - 22:01:47 CEST

Original text of this message