Re: Data block associated to a stored procedure

From: Patrick Flahan <flahan_at_earthlink.net>
Date: Sun, 2 May 1999 19:03:42 -0400
Message-ID: <7gilnb$1r$1_at_oak.prod.itd.earthlink.net>


All you have to do is add the additional parameters to the stored procedure and in forms you go to the Query Data Source Arguments property and set the value.

Hope this helps,
Patrick Flahan
flahan_at_earthlink.net

Joaquin Garcia Santos <jis_at_iberdrolaingenieria.es> wrote in message news:7gca5o$o6p$1_at_talia.mad.ttd.net...
> Hello,
> First at all, excuse my not very good english.
> I want to create a block associate to a stored procedure, but I want that
> this procedure have an input argument.
> According to the demo form, how will be the query procedure?
> type emp_dname is record (
> empno number(4),
> ...
> );
> type emp_dname_ref is ref cursor return emp_dname;
> procedure query(resultset in out demp_dname_ref) is
> begin
> open resultset for
> select e ...
> end;
> And how do I pass the input argument from forms?
>
> Thanks a lot.
>
>
Received on Mon May 03 1999 - 01:03:42 CEST

Original text of this message