Re: PL/SQL

In article <a7eoh1$efc$1_at_reader1.imaginet.fr>, "Laurent says...
>
>ho! ho!
>Your solution might interest me....
>Would you mind giving an exemple please ????

I assume the ho ho it because you know that what is suggested is not possible...

anyway, you want to use a dynamically opened ref cursor if you truly need this level of genericity.

declare

   type rc is ref cursor;

   l_cursor rc;
   l_string varchar2(30000);
begin

    l_string := .....;
    open l_cursor for l_string;
    loop

       fetch l_cursor into l_variables....;
       exit when l_cursor%notfound;

>
>Thanks very much in advance....
>Laurent
>
>"Richard Kuhler" <noone_at_nowhere.com> a écrit dans le message de news:
>6Zom8.53$Q2.165197_at_twister.socal.rr.com...
>> It's difficult to say what the best solution is without seeing the whole
>> picture. However, you might consider dynamically creating a private
>> synonym at the beginning of the code to point to the correct table.
>> Then just use the synonym everywhere in the rest of the code.
>>
>> Richard Kuhler
>>
>> Laurent Boutet wrote:
>> >
>> > Hi,
>> >
>> > Here is my question :
>> >
>> > In my stored proc, I copy 2 times likely the same code. I mean, the code
>is
>> > just a bit different for instance :
>> >
>> > if param=1 then
>> > select * from table1;
>> > else
>> > select * from table2;
>> >
>> > This is a very basic code...but imagine I have hundred lines !!!
>> > If only I could do such a code :
>> > select * from table<param>
>> >
>> > So I would just have to set the param value...for instance, param=2
>then, I
>> > would have select * from table2;
>> >
>> > How can I do such a thing ??????
>> >
>> > I hope you understand my problem...
>> >
>> > Thanks in advance,
>> > Laurent
>>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp