Re: cursor variables

[Quoted] "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 Tue Jun 27 2000 - 00:00:00 CEST