This code looks the same as what you submitted earlier. The package body does not compile either. I am not sure what you are trying to do with the RTRIM function. I see that you will get for the first example 1 + 1 + 1 +1; end; but then what?
I have tried to compile the package body on 8.1.6/Solaris and 9i/NT and both bomb at concatenated string ( || ) on RTRIM code line. Is this the correct code you are submitting? --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Hmmm .... there is a small error .... > > The package body should be as follows > > CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS > -- > PROCEDURE eval_this (pi_string IN VARCHAR2) IS > BEGIN > RTRIM(pi_string,';') || '; end;'; > END eval_this; > -- > END My_Dynamic_Stuff; > / > > this of course assumes that you are on 8i or better version, if you > are on > pre 8i version, change code appropriately to use dbms_sql package > instead of > NDS. > HTH > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of > ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > *********************************************************************2 > > This e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is privileged, > attorney work product or exempt from disclosure under applicable law. > If you have received this message in error, or are not the named > recipient(s), please immediately notify corporate MIS at (860) > 766-2000 and delete this e-mail message from your computer, Thank > you. > > *********************************************************************2 > > ===== Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).