Glad it worked. Make sure you test it well. Mike On Tue, May 25, 2010 at 2:32 PM, reach manju <[email protected]> wrote:
> Perfect Mike!.. You are great. Just modified a bit to fit in.. It > works..:-) > I can trap, no_data_found as well. > > Thanks Tons! > Thanks for all the help. > > ~Manju > > > On Tue, May 25, 2010 at 1:00 PM, reach manju <[email protected]> wrote: > >> You are right Andrej, I forgot to mention INTO in the statement, >> >> I am working on the suggestion given by Mike. Shall post the results soon. >> m sure it should work for the scenario I have..:-) >> >> >> On Tue, May 25, 2010 at 12:31 PM, Andrej Hopko <[email protected]>wrote: >> >>> it's okay - I hadn't even read the error details and just shout what I >>> saw >>> >>> now I found, that NO_ROWS_FOUND may be used >>> I use only NO_DATA_FOUND for handling this kinf og exception >>> (and have no idea of difference between them =) ) >>> >>> regards, >>> >>> Andrej Hopko >>> >>> >>> On 25. 5. 2010 21:26, Michael Moore wrote: >>> >>> Yes, my example was for straight SQL. I assumed that Manju would know how >>> to put it into a PL/SQL context. >>> Regards, >>> Mike >>> >>> On Tue, May 25, 2010 at 12:21 PM, Andrej Hopko <[email protected]>wrote: >>> >>>> in PL/SQL context this select syntax does not work >>>> >>>> >>>> On 25. 5. 2010 18:56, reach manju wrote: >>>> >>>> select...from tab1 >>>> where col1=c1.col1 and col2=c1.col2 >>>> >>>> >>>> select...from tab1 >>>> *INTO variable* >>>> >>>> where col1=c1.col1 and col2=c1.col2 >>>> >>>> you forgot INTO statement which is mandatory! >>>> >>>> Andrej Hopko >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Oracle PL/SQL" group. >>>> To post to this group, send email to [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected] >>>> For more options, visit this group at >>>> http://groups.google.com/group/Oracle-PLSQL?hl=en >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Oracle PL/SQL" group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected] >>> For more options, visit this group at >>> http://groups.google.com/group/Oracle-PLSQL?hl=en >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Oracle PL/SQL" group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected] >>> For more options, visit this group at >>> http://groups.google.com/group/Oracle-PLSQL?hl=en >>> >> >> > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
