Basing Block on Stored Proc....

[Roy Munson]

each,

am basing a block on a cursor in a packaged procedure. my question is i
also want to return other details in other 'in out' parameters to be
shown on the form.

Can this be done....

p_procname (inparam1 in number,
outparam1 in out varchar2,
refcursor in out cur_type);

block based on the refcursor but want to also display the details
returned in outparam1....

cheers

[DA Morgan]

mtproc@yahoo.co.uk wrote: each, am basing a block on a cursor in a packaged procedure. my question is i also want to return other details in other 'in out' parameters to be shown on the form. Can this be done.... p_procname (inparam1 in number, outparam1 in out varchar2, refcursor in out cur_type); block based on the refcursor but want to also display the details returned in outparam1.... cheers

Database version?
Forms version?
Why not try it?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Roy Munson]

cos it was the end of the day....thought if i posted on here i might
get an answer overnight from some kind soul across the pond saving me
the time this morning....

obviously not....why bother responding if you arent gonna post
something useful.

i shall try it myself and post my results on this thread later.


DA Morgan wrote: mtproc@yahoo.co.uk wrote: each, am basing a block on a cursor in a packaged procedure. my question
is i also want to return other details in other 'in out' parameters to
be shown on the form. Can this be done.... p_procname (inparam1 in number, outparam1 in out varchar2, refcursor in out cur_type); block based on the refcursor but want to also display the details returned in outparam1.... cheers Database version? Forms version? Why not try it? -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)

[Noel]

Użytkownik Miggins napisał: i shall try it myself and post my results on this thread later.

Don't forget to cross and top your post.

--
Noel

[DA Morgan]

Miggins wrote: cos it was the end of the day....thought if i posted on here i might get an answer overnight from some kind soul across the pond saving me the time this morning.... obviously not....why bother responding if you arent gonna post something useful. i shall try it myself and post my results on this thread later. DA Morgan wrote:mtproc@yahoo.co.uk wrote:each,am basing a block on a cursor in a packaged procedure. my question is ialso want to return other details in other 'in out' parameters to beshown on the form.Can this be done....p_procname (inparam1 in number, outparam1 in out varchar2, refcursor in out cur_type);block based on the refcursor but want to also display the detailsreturned in outparam1....cheersDatabase version?Forms version?Why not try it?--Daniel A. Morganhttp://www.psoug.orgdamorgan@x.washington.edu(replace x with u to respond)

You made two mistakes.

The first that you assumed we are a substitute for working. We volunteer
our time to help people that help themselves.

The second that you top posted. Do it again and you will likely be
ignored.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)