Home » SQL & PL/SQL » SQL & PL/SQL » how to handle
how to handle [message #37712] Fri, 22 February 2002 11:09 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
Hi,
Iam having problem using a dynamic sql
iam select distinct ids into myids from table1
iam getting a error saying select into too many rows.

How to handle this problem situation.
i the reason iam not using a stored proc is, i just need a id.

Appreciate any help
sam
Re: how to handle [message #37720 is a reply to message #37712] Sun, 24 February 2002 23:46 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
The statement
"select id into temp_var ..." expects only one row to be retrieved , otherwise it will raise an error

workaround
-----------

1. put where clause, so that it returns only one row
2. OR, create cursor to handle this
Previous Topic: Urgent
Next Topic: a statement
Goto Forum:
  


Current Time: Fri Sep 17 02:53:26 CDT 2021