Re: running sql script via oracle forms 5

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Mon, 29 Oct 2001 19:03:32 GMT
Message-ID: <8KhD7.15396$EO1.2064321@news1.news.adelphia.net>

Short answer: YES

Longer answer: you can easily use form fields as variables in the Where clause, just preface the field name with a colon ":". Like i n

select count(*)
into my_count
from my_table_name_here
where field_1 > :tx_number;

It is more involved, but you can also use form fields in the Select and From portions.

"Jeanette Weldon" <jeanette.weldon3_at_virgin.net> wrote in message news:ZnhD7.22720$GA.3033695_at_news2-win.server.ntlworld.com...
> Is it possible to run an sql script on an oracle 8i database via an input
> parameter from oracle forms 5 ?
>
>
Received on Mon Oct 29 2001 - 13:03:32 CST