Re: How to pass parameter back to the called form?
Date: Mon, 26 Apr 1999 14:20:53 +0400
Message-ID: <37243E05.73F60DD6_at_dd.ru>
Hi Steve,
Thank you for your correction.
Yes, in Forms there is an Implementation Restriction about directly access to remote package variable. And Forms developers have to use procedures or functions to set and to get the package variables.
But as you know there is a restriction to global variables length - up to 255 characters. But in the packages you can use other data types and length, and you can use even PL/SQL tables as well.
Thank you again and sorry for clearness in my previous recommendation.
With best wishes,
Valeri
Steve Cosner wrote:
>
> Package variables in server-side packages are not accessible by Forms,
> even Forms 5. If you are going to use a package, you have to call a
> procedure or function in the package to set and return the number.
>
> Rather than create the additional package and package body on the
> server, the simpler solution in this situation would be to use a
> global variable to return a value from a called form.
>
> Steve Cosner
> http://members.aol.com/stevec5088
>
> >Valeri Sorokine (vsorokin_at_dd.ru) wrote:
> >: The package must be in the database :) (not in the Form). The variable
> >: must have the public scope (must be declared in the package's
> >: specification).
> >
> >: Here is an example (in SQL*Plus):
> >
> >: SQL> CREATE OR REPLACE PACKAGE TEST IS
> >: 2 tmp_Value NUMBER;
> >: 3 END TEST;
> >: 4 /
> >
> >: Package created.
> >
> >: SQL> execute test.tmp_value := 4;
> >
> >: PL/SQL procedure successfully completed.
> >
> >: SQL> variable tmp number;
> >: SQL> execute :tmp := test.tmp_value;
> >
> >: PL/SQL procedure successfully completed.
> >
> >: SQL> print tmp
> >
> >: TMP
> >: ----------
> >: 4
> >
> >: When you will open the second form do it without creating new session.
> >
> >: Hope this helps.
> >
> >: Good Luck.
> >: Valeri
> >
> >: suisum_at_ecn.ab.ca wrote:
> >: >
> >: > Hi Valeri:
> >: >
> >: > Thank you very much for your reply.
> >: >
> >: > Would you mind to show me an example how to use package variable, please?
> >: > Will the package in the calling form or the package in the callled form?
> >: >
> >: > Thanks,
> >: >
> >: > Valeri Sorokine (vsorokin_at_dd.ru) wrote:
> >: > : Or package's variable
> >: >
> >: > : Frank van Bortel wrote:
> >: > : >
> >: > : > Use global variables
> >: > : >
> >: > : > suisum_at_ecn.ab.ca wrote:
> >: > : >
> >: > : > > If I use OPEN_FORM or CALL_FORM to call up a 2nd form, is there any
> >: > : > > way to return a value back to the called form from the calling form?
-- Valeri Sorokine ProSoft, Russia, Moscow, Information Systems Division Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640 E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru http://www.dd.ruReceived on Mon Apr 26 1999 - 12:20:53 CEST