Re: Whats the error here

Ravi Joseph Pinto wrote: } } In reply to S.Sathish's email about Whats the error here, on 13 Nov } 97 } } Hi Satish, } } } create procedure proc_tmp () } } returning int; } } define x int; } } on exception in (-206) } } create table proc_tab (col1 char(15)); } } insert into proc_tab values ("1000"); } } end exception with resume } } insert into proc_tab values ("1000") } } let x = select count(*) from proc_tab; } } SELECT COUNT(*) INTO x FROM proc_tab ; There is nothing wrong in the previous 'let' statement, except for the brackets: let x = (select count(*) from proc_tab); should do the job. } } } } } ^ 201: A syntax error has occurred. } } # } } # } } return x; } } } } } } end procedure } } } } } } ****************************************************************************** } } S.Sathish } } email :ssathish@cmcbang.ernet.in } } ****************************************************************************** } } HTH, } Ravi... } -- } Ravi Joseph Pinto, mailto:ravi@in.dhl.com } Senior Consultant, voice :91-22-8503000 extn. 1531 } AFL Infotech, Mumbai, India } } Unix, C, Informix, Tuxedo } } PS : Standard disclaimers apply.