the error points to the Fetch statement Fetch C1 into froup_id,group_name
It will be great if somebody has done sql manipulations on the C104 filed of
the t9(User Form)

On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza <jdso...@shyle.net> wrote:

> **
> What is the error that you are getting?
>
> Joe
>
>  -----Original Message-----
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org]*on Behalf Of *amit dw
> *Sent:* Tuesday, February 16, 2010 4:20 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* SQL help needed
>
> **
>   Hello All,
>
>
> Below is the problem and way I was trying to handle it
>
>
>
> C_list contains comma separated values of group Id’s. this list contains
> all the group id’s associated to a particular login name.
>
>
>
> C_list= (1,15005,800005,800003,800004,805)
>
>
>
> This variable will be holding up dynamically value in numbers.
>
>
>
> For group id numbers in simple sql statement we can get the result
> corresponding name using the below query,
>
>
>
> Select c105,c106 from t10 where c106 in (1, 101,102,104).
>
>
>
> Same query when I tried transforming in a cursor it throws up a compilation
> error. The error points out to a fetch statement where we try and fetch the
> data from the cursor for one particular group id.
>
>
>
> Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list);
>
> Begin
>
> Open c1;
>
> Loop
>
> Fetch C1 into g_num,g_name;
>
> dbms_output.put_line(g_name);
>
> EXIT WHEN C1%NOTFOUND;
>
> END LOOP;
>
> Close c1;
>
> End;
>
>
>
> Hope it explains the problem I am facing.
>
> Any suggestions/Comments or previously implemented code will be helpful for
> me.
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Reply via email to