Thanks so much for your time and effort.
Correct code was found in the attachement. It compiles and runs as you
described. You found a very innovative way of converting the string to
an expression.
I will need to check on whether it creates the Shared or non-shared
SQL.
That will be the determining factor for us to use it.
If it works, you could save my project at least a month of effort.
So thanks for help.
Shakir
- "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
> Here you go
>
> 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!
>
>
> -----Original Message-----
> From: Mohammed Shakir [mailto:mshakir08816_at_yahoo.com]
> Sent: Thursday, April 04, 2002 12:25 PM
> To: Jamadagni, Rajendra
> Subject: RE: Literal SQL and sys.dual
>
>
> Thanks for your help and sending the code three times. I know it can
> be
> a bother.
>
> However, Can you just tell me in a yes/no, if this is the code you
> are
> sending me? The code I have received it is shown below.
>
> Thanks
>
> Shakir
>
> --- "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
> > For the 3rd time I am sending this code, Mohammad, it wouldn't be a
> > bad idea
> > to try to resolve the code yourself.
> >
> > CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS
> > v_result NUMBER;
> > --
> > PROCEDURE eval_this (pi_string IN VARCHAR2) IS
> > BEGIN
> > RTRIM(pi_string,';') || '; end;';
> > END eval_this;
> > --
> > END My_Dynamic_Stuff;
> > /
> >
> > If the mail software is truncating it, I can't help.
> > 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!
> > >
>
> ***1
> >
> > 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 ESPN at (860) 766-2000 and
> > delete this e-mail message from your computer, Thank you.
> >
> >
>
> ***1
> >
>
>
> =====
> 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/
>
>
> ATTACHMENT part 2 application/octet-stream name=MY_DYNAMIC_STUFF.PKS
>
>
*********************************************************************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: mshakir08816_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Thu Apr 04 2002 - 13:18:35 CST
