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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help !!!ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Re: Help !!!ORA-06502: PL/SQL: numeric or value error: character to number conversion error

From: JC <joseph.chewning_at_targacept.com>
Date: 28 Mar 2006 17:35:08 -0800
Message-ID: <1143596107.970193.36600@u72g2000cwu.googlegroups.com> 





I figured it out!



what I needed to do is this:



execute immediate 'select '||mcn||' from lot_final_values where
lot_id='||lotid||' and rowid='''||mrn||''' into colvalue;



Thanks for your help and the four feet of garden hose!!!!
Received on Tue Mar 28 2006 - 19:35:08 CST












Original text of this message













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