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]
<mailto:[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]
<mailto:[email protected]>
To unsubscribe from this group, send email to
[email protected]
<mailto:[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
