refering form objects in Pl/SQL

hi,
me a novice..
i've got a form with a one text item(Balance:name'bal') and a button(Show balance).
When the button is pressed the text item should display the balnce of account_id 3....this is what i have done:

begin
select bal into 'bal' from accounts
where account_id = 3;
end;

when i compile it it gives e error saying: simple name required in this request.

ANyone please...anyone

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!