| error while getting more than values [message #675520] |
Wed, 03 April 2019 05:46  |
 |
compuscience
Messages: 97
Registered: September 2012
|
Member |
|
|
i need to make loop to get column from select statment
by the following code if i have one record the code run okay
if i have more than one i get error ora-01422
PROCEDURE hide IS
name_v varchar2(50);
BEGIN
select name
into name_v
from maxit
where tag_no = :global.tag_no;
if name_in ('system.cursor_item') = name_v then
next_item;
end if;
set_item_property(name_v,visible,property_false);
END;
[EDITED by LF: reformatted, applied [code] tags]
[Updated on: Wed, 03 April 2019 15:31] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: error while getting more than values [message #675529 is a reply to message #675525] |
Wed, 03 April 2019 08:32  |
cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Well I've no idea what you actually want that procedure to do.
It's hard to work out what someone wanted some code to do when the only thing you've got to work with is some code that doesn't do what they wanted.
Explain in words what you want the code to do.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
