Re: cursor variables

Thanks, Matt! I tried that before. It didn't like the symbol 'REF'.

Kevin

Matt B. <mcb_at_fightspam.sd.znet.com> wrote in message news:slipgp7kjev63_at_corp.supernews.com...
> "kzheng" <kzheng_at_canada.com> wrote in message
> news:pN565.121$EB2.8249_at_jekyl.ab.tac.net...
> > I 've used cursor variables for store procedures on the server. Now, I
 am
> > considering using cursor variables on the client. So first question
 is -can
> > I do it? (I am using Forms 4.5, by the way.)
> >
> > In a program unit, say function My_Function_A returns the cursor
 variable
> > and My_Procedure_ B fetches the data and inserts data to another table.
 (Of
> > course, you can use one procedure instead.) The reason for doing it is
 that
> > there are six input combinations on the user input block. Can someone
 review
> > the code and give me some hint on syntax so that it can work on the
 client
> > application as well. I hope to call this procedure in
> > when-new-block-instance trigger.
> >
> > Any help will be greatly appreciated!
> >
> > With PL/SQL (2.3 and higher) I would write something like this (all in
 one.)
> >
> > CREATE OR REPLACE PROCEDURE Show_Charges
> > (p_Input IN number) AS
>
> Try:
>
> PROCEDURE SHOW_CHARGES(P_INPUT IN NUMBER) IS
> <your code here>
>
> Don't use "create or replace" and use "IS" instead of "AS".
>
> -Matt
>
>
Received on Wed Jun 28 2000 - 00:00:00 CEST