Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: select inside a cursor problem

Re: select inside a cursor problem

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 14 May 2003 08:31:42 -0700
Message-ID: <1b061893.0305140731.a6ed491@posting.google.com> 





Try to give more details on the tables involved please (fields, # of
records, ...). Just an idea: are you sure that there are as many
records as you think in "vw" that are referenced exactly once in
"people"? If you remove the statement "if v_id_cnt = 1 then", do you
get all the results you would expect? Besides that, I see nothing
wrong with your code. You can email me with more details if you want.



Daniel
Received on Wed May 14 2003 - 10:31:42 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US