The first query says "where FK_USER in (44541,41402,41813)" and the second query says "where PEN_ID in (44541,41402,41813)"...
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 11:43 PM > Hi, > > My brain is slow today.... Can someone help me ? > > I can do : > > select idu+1 from user_group_members where fk_user > in(44541,41402,41813) ; > > IDU+1 > ---------- > 41411 > 41821 > 44546 > > But I can't do : > select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values ('||IDU + 1 ||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from app_users > where pen_id in (44541,41402,41813) ; > > I've got on IDU+1 : > > ERROR at line 1: > ORA-01722: invalid number > > > Best Regards > Henrik > > -- > -------------------------------------------------------------------------- - > There's fun in being serious. > > -- Wynton Marsalis > > Henrik Ekenberg Anoto AB > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Henrik Ekenber > INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).