|
Re: getting value from db [message #588917 is a reply to message #588886] |
Sat, 29 June 2013 14:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It works, but doesn't do what you wanted it to. Select into an item directly, such as
select ic_id
into :block.display_item_name
from cd_details
where price = 599;
P.S. Alternatively, in your code, you miss the following:
select ...
:block.display_item_name := num;
end;
[Updated on: Sat, 29 June 2013 14:06] Report message to a moderator
|
|
|
Re: getting value from db [message #588918 is a reply to message #588886] |
Sat, 29 June 2013 14:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
What makes you think that code doesn't work?
Of course you should probably be fetching the value into a display item rather than a local variable. There's not a lot of point selecting a value if you do nothing with it.
|
|
|
|
|
|
|
|