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
