Re: PL/SQL cursor

Pillarisetti Sivaram (ps42_at_ciao.cc.columbia.edu) wrote:
: I have a PL/SQL cusror question.
 

: I am using a cursor in PL/SQL procedure to select some rows
: from one table into the cursor and update rows in the second table. I am
: using for loop to update the second table's rows with the rows from
: the cursor. The cursor does not seem to work. There are no statements
: selected into the cursor. If I use SQL statement to select the rows,
: I am seeing the rows. Also the same PL/SQL procedure works on other
: system. Is something missing in the PL/SQL installation on this system?
: I am not getting any error messages either. I get the message PL/SQL
: procedure successfully completed.
 

: Any answers would be greatly appreciated.
 

: Thanks

Are you doing all these things:

DECLAREing the cursor
OPENing the cursor
FETCHing into the cursor
UPDATEing or INSERTing into the new table then CLOSEing the cursor?

Should work
Maybe you can post your procedure...
Good luck
Randy

--
   ..uu.                   z'                 ,   ___________________
  ?$""`?i      .          x"                .uu   I     Randy       I
  `M  ._at_"     d9b    .    f   .,.uun.  ?$   ?i'   I   DeWoolfson    I
  'Z :#"     M `8   U8   <   .dP"```"# `M  ._at_"    I-----------------I
  '&H?`     X ,oR   $5.  $   ?*     _at_  'Z :#"     I randyd_at_cais.com I
  d#`*L    :RP' $b  f`$L:M   Xf   .f'  '&H?`      I-----------------I
,!">  5.   $'   ?X  X  "NXF  M  .=`    d#`        I     ,\\/.       I
   >  'M  d$    `E  M   "$$  Mux~    n!"          I     |o o|       I
   k   `h '     '  ""    `   z"     *             I=ooO==(_)==Ooo===I
   %     `                  "      "              I_________________I