Re: refering form objects in Pl/SQL

Try:

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

saf <psarfarazNOpsSPAM_at_hotmail.com.invalid> wrote:

>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!

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Mar 13 2000 - 10:58:07 CST