Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2010
    Location
    tunis
    Posts
    2

    Unanswered: how work function in forms 10g

    i have a package in My DB
    CREATE OR REPLACE PACKAGE EXPLOIT.GETLIB AS

    FUNCTION IDENTITE (MAT IN NUMBER) RETURN VARCHAR2;
    FUNCTION LIB_CENTRE (CENT IN NUMBER) RETURN VARCHAR2;
    FUNCTION LIB_AGENCE (CENT IN NUMBER,AGC IN NUMBER) RETURN VARCHAR2;
    FUNCTION LIB_GRP_SERV (CENT IN NUMBER,AGC IN NUMBER ,GRP IN NUMBER ) RETURN VARCHAR2;
    FUNCTION LIB_GRP_BINOM (CENT IN NUMBER,AGC IN NUMBER ,GRP IN VARCHAR2 ) RETURN VARCHAR2;
    FUNCTION LIB_PERIODE (PER IN VARCHAR2 ) RETURN VARCHAR2;
    FUNCTION LIB_SERV (CENT IN NUMBER,AGC IN NUMBER ,SRV IN VARCHAR2 ) RETURN VARCHAR2;
    END GETLIB;
    /


    now i want to work with this function
    FUNCTION LIB_AGENCE (CENT IN NUMBER,AGC IN NUMBER) RETURN VARCHAR2;

    in forms developer post_chane declencher ... i dont know how to use

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    in forms developer post_chane declencher
    What the heck is that?

    Anyway: you'd use that function in Forms as you'd use it anywhere else - put its value into a variable (or a block item), such as
    Code:
    declare
      l_var varchar2(20);
    begin
      l_var := exploit.getlob.lib_agence(:block.cent, :block.agc);
    
      -- or
    
      :block.agence := exploit.getlob.lib_agence(:block.cent, :block.agc);
    end;
    Note that this is just an example; variable's declaration should reflect actual situation, as well as block and item names.

  3. #3
    Join Date
    Nov 2010
    Location
    tunis
    Posts
    2

    Thumbs up

    thank you ... i have do it !

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •