Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    3

    Unanswered: FRM-30087: Unable to create form file D:\rani\GEN_RECT.fmx.

    if i try to run gen_rect.fmx individually it is giving error like below
    Compiling QUERY-PROCEDURE trigger on RECEIPT_RESULT_BLK data block...
    No compilation errors.
    FRM-30087: Unable to create form file D:\rani\GEN_RECT.fmx.

    Iam sending u the code in the query_procedure and goodnews package.
    can u pls clarify my doubt.
    iam modifying this form bou not able to save


    DECLARE
    bk_data GOODNEWS_PKG.GEN_RECT_TABLE;
    BEGIN
    GOODNEWS_PKG.GEN_RECT_PROC(bk_data, :RECEIPT_FIND_BLK.D_CODE, :RECEIPT_FIND_BLK.D_NAME, :RECEIPT_FIND_BLK.RECT_DATE, :RECEIPT_FIND_BLK.GL_TRUST_CODE, :RECEIPT_REGISTER_BLK.G_YEAR_START, :RECEIPT_REGISTER_BLK.G_YEAR_END);
    PLSQL_TABLE.POPULATE_BLOCK(bk_data, 'RECEIPT_RESULT_BLK');
    END;

    PACKAGE BODY GOODNEWS_PKG IS

    PROCEDURE CITY_STATE_MASTER_PROC(CITY_MASTER_DATA IN OUT CITY_STATE_MASTER_TAB, CITY_CODE_PARAM IN NUMBER, CITY_NAME_PARAM IN VARCHAR2,STATE_NAME_PARAM IN VARCHAR2, COUNTRY_NAME_PARAM IN VARCHAR2) IS
    I BINARY_INTEGER :=1 ;
    CURSOR CITY_CUR IS
    SELECT * FROM CITY_MASTER_TAB
    WHERE (CITY_CODE LIKE CITY_CODE_PARAM||'%' )
    AND (UPPER(CITY_NAME) LIKE CITY_NAME_PARAM||'%' )
    AND (UPPER(STATE_NAME) LIKE STATE_NAME_PARAM||'%' )
    AND (UPPER(COUNTRY_NAME) LIKE COUNTRY_NAME_PARAM||'%');
    BEGIN
    OpEN CITY_CUR;
    LOOP
    FETCH CITY_CUR INTO CITY_MASTER_DATA(I).C_CODE, CITY_MASTER_DATA(I).C_NAME,CITY_MASTER_DAtA(I).S_N AME,CITY_MASTER_DATA(I).COUN_NAME;
    EXIT WHEN CITY_CUR%NOTFOUND;
    I:=I+1;
    END LOOP;
    CLOSE CITY_CUR;

    END CITY_STATE_MASTER_PROC;


    PROCEDURE RECEIPT_MASTER_PROC(RECEIPT_MASTER_DATA IN OUT RECEIPT_MASTER_TABLE, DONOR_CODE_PARAM IN NUMBER,DONOR_NAME_PARAM IN VARCHAR2, RECEIPT_DATE_PARAM IN DATE, SL_NO_PARAM IN NUMBER) IS


    CURSOR RECEIPT_MASTER_CUR IS
    SELECT R.DONOR_CODE,R.RECT_DATE, R.SL_NO,FIRST_NAME
    FROM RECEIPT_REGISTER_TAB R , DONOR_TAB D
    WHERE(R.DONOR_CODE = D.DONOR_CODE) AND
    (( R.DONOR_CODE LIKE DONOR_CODE_PARAM||'%' )
    AND (( UPPER(D.FIRST_NAME)IN (SELECT FIRST_NAME FROM DONOR_TAB
    WHERE FIRST_NAME LIKE DONOR_NAME_PARAM||'%'))
    AND ( R.RECT_DATE LIKE RECEIPT_DATE_PARAM||'%')
    AND ( R.SL_NO LIKE SL_NO_PARAM||'%' )))
    ORDER BY R.DONOR_CODE;

    I BINARY_INTEGER:=1;

    BEGIN
    OPEN RECEIPT_MASTER_CUR;
    LOOP
    FETCH RECEIPT_MASTER_CUR INTO RECEIPT_MASTER_DATA(I).D_CODE,
    RECEIPT_MASTER_DATA(I).R_DATE,
    RECEIPT_MASTER_DATA(I).R_SL_NO,
    RECEIPT_MASTER_DATA(I).D_NAME;
    EXIT WHEN RECEIPT_MASTER_CUR%NOTFOUND;
    I:=I+1;
    END LOOP;


    END RECEIPT_MASTER_PROC;




    PROCEDURE DONOR_PROC(DONOR_DATA IN OUT DONOR_MASTER_TAB, DONOR_CODE_PARAM IN NUMBER, DONOR_NAME_PARAM IN VARCHAR2,CITY_NAME_PARAM IN VARCHAR2) IS

    CURSOR DONOR_CUR IS
    SELECT D.DONOR_CODE, D.FIRST_NAME, C.CITY_NAME FROM DONOR_TAB D, CITY_MASTER_TAB C
    WHERE D.CITY_CODE = C.CITY_CODE AND
    ( (D.DONOR_CODE LIKE DONOR_CODE_PARAM||'%' )
    AND (UPPER(D.FIRST_NAME) IN (SELECT FIRST_NAME FROM DONOR_TAB
    WHERE FIRST_NAME LIKE DONOR_NAME_PARAM||'%')
    AND ((UPPER(C.CITY_NAME) LIKE CITY_NAME_PARAM||'%')
    )))
    ORDER BY DONOR_CODE;

    I BINARY_INTEGER:=1;

    BEGIN
    OPEN DONOR_CUR;
    LOOP
    FETCH DONOR_CUR INTO DONOR_DATA(I).D_CODE,
    DONOR_DATA(I).D_NAME,
    DONOR_DATA(I).C_NAME;

    EXIT WHEN DONOR_CUR%NOTFOUND;
    I:=I+1;
    END LOOP;
    CLOSE DONOR_CUR;

    END DONOR_PROC;


    PROCEDURE DONOR_PROGRAM_PROC(DONOR_DATA IN OUT DONOR_PROGRAM_TABLE, DONOR_CODE_PARAM IN NUMBER, DONOR_NAME_PARAM IN VARCHAR2,CITY_NAME_PARAM IN VARCHAR2, GLOBAL_TRUST_CODE IN NUMBER) IS

    CURSOR DONOR_PROG_CUR IS
    SELECT DISTINCT(P.DONOR_CODE), D.FIRST_NAME, C.CITY_NAME FROM DONOR_PROG_TAB P,DONOR_TAB D,TITLE_TAB T, CITY_MASTER_TAB C
    WHERE P.DONOR_CODE=D.DONOR_CODE AND
    P.TRUST_CODE = GLOBAL_TRUST_CODE AND
    D.TITLE_CODE = T.TITLE_CODE AND
    D.CITY_CODE = C.CITY_CODE AND
    ( (D.DONOR_CODE LIKE DONOR_CODE_PARAM||'%' )
    AND (UPPER(D.FIRST_NAME) IN (SELECT FIRST_NAME FROM DONOR_TAB
    WHERE FIRST_NAME LIKE DONOR_NAME_PARAM||'%')
    AND ((UPPER(C.CITY_NAME) LIKE CITY_NAME_PARAM||'%')
    )))
    ORDER BY P.DONOR_CODE;

    I BINARY_INTEGER:=1;

    BEGIN
    OPEN DONOR_PROG_CUR;
    LOOP
    FETCH DONOR_PROG_CUR INTO DONOR_DATA(I).D_CODE,
    DONOR_DATA(I).D_NAME,
    DONOR_DATA(I).C_NAME;

    EXIT WHEN DONOR_PROG_CUR%NOTFOUND;
    I:=I+1;
    END LOOP;
    CLOSE DONOR_PROG_CUR;
    END DONOR_PROGRAM_PROC;


    PROCEDURE RECEIPT_DETAILS_PROC(RECEIPT_DETAILS_DATA IN OUT RECEIPT_DETAILS_TABLE, DONOR_CODE_PARAM IN NUMBER,DONOR_NAME_PARAM IN VARCHAR2, RECEIPT_DATE_PARAM IN DATE, SL_NO_PARAM IN NUMBER, GLOBAL_TRUST_CODE IN NUMBER,YEAR_START_PARAM IN DATE, YEAR_END_PARAM IN DATE) IS


    CURSOR RECEIPT_DETAILS_CUR IS
    select m.donor_code,
    rect_date,sl_no,
    D.FIRST_NAME,
    mode_code
    from receipt_master_tab m,donor_tab d,title_tab t
    where m.donor_code=d.donor_code
    and d.title_code=t.title_code
    and m.trust_code= GLOBAL_TRUST_CODE
    and m.rect_date >= year_start_PARAM
    and m.rect_date <= year_end_PARAM
    AND M.DONOR_CODE LIKE DONOR_CODE_PARAM||'%'
    AND D.FIRST_NAME LIKE DONOR_NAME_PARAM||'%'
    AND RECT_DATE LIKE RECEIPT_DATE_PARAM||'%'
    AND SL_NO LIKE SL_NO_PARAM||'%'
    ORDER BY D.DONOR_CODE;





    /*
    CURSOR RECEIPT_DETAILS_CUR IS
    SELECT R.DONOR_CODE,R.RECT_DATE, R.SL_NO,FIRST_NAME
    FROM RECEIPT_REGISTER_TAB R , DONOR_TAB D
    WHERE(R.DONOR_CODE = D.DONOR_CODE) AND
    (( R.DONOR_CODE LIKE DONOR_CODE_PARAM||'%' )
    AND (( UPPER(D.FIRST_NAME)IN (SELECT FIRST_NAME FROM DONOR_TAB
    WHERE FIRST_NAME LIKE DONOR_NAME_PARAM||'%'))
    AND ( R.RECT_DATE LIKE RECEIPT_DATE_PARAM||'%')
    AND ( R.SL_NO LIKE SL_NO_PARAM||'%' )))
    ORDER BY R.DONOR_CODE;
    */
    I BINARY_INTEGER:=1;
    BEGIN
    OPEN RECEIPT_DETAILS_CUR;
    LOOP
    FETCH RECEIPT_DETAILS_CUR INTO RECEIPT_DETAILS_DATA(I).D_CODE,
    RECEIPT_DETAILS_DATA(I).R_DATE,
    RECEIPT_DETAILS_DATA(I).R_SL_NO,
    RECEIPT_DETAILS_DATA(I).D_NAME,
    RECEIPT_DETAILS_DATA(I).M_CODE;
    EXIT WHEN RECEIPT_DETAILS_CUR%NOTFOUND;
    I:=I+1;
    END LOOP;
    CLOSE RECEIPT_DETAILS_CUR;
    END RECEIPT_DETAILS_PROC;

    --PROCEDURE

    PROCEDURE RECEIPT_DETAILS_ADD_PROC(RECEIPT_DETAILS_DATA IN OUT RECEIPT_DETAILS_ADD_TABLE, DONOR_CODE_PARAM IN NUMBER,DONOR_NAME_PARAM IN VARCHAR2, RECT_CODE_PARAM IN NUMBER,RECEIPT_DATE_PARAM IN DATE, SL_NO_PARAM IN NUMBER, GLOBAL_TRUST_CODE IN NUMBER, YEAR_START_PARAM IN DATE, YEAR_END_PARAM IN DATE) IS
    CURSOR RECEIPT_DETAILS_ADD_CUR IS
    select r.DONOR_CODE,
    D.FIRST_NAME,
    R.RECT_CODE,
    rect_date,
    sl_no,
    mode_code
    from receipt_master_tab r,donor_tab d,title_tab t
    where
    r.donor_code=d.donor_code
    and d.title_code=t.title_code
    and r.year_start = year_start_PARAM
    and r.trust_code=GLOBAL_TRUST_CODE
    and (r.rect_code,r.mode_code) not in (select rect_code,mode_code from receipt_detail_tab where year_start = year_start_PARAM and trust_code=GLOBAL_TRUST_CODE)
    AND R.DONOR_CODE LIKE DONOR_CODE_PARAM||'%'
    AND D.FIRST_NAME LIKE DONOR_NAME_PARAM||'%'
    AND RECT_DATE LIKE RECEIPT_DATE_PARAM||'%'
    AND SL_NO LIKE SL_NO_PARAM||'%'
    ORDER BY R.DONOR_CODE;

    I BINARY_INTEGER :=1;

    BEGIN
    OPEN RECEIPT_DETAILS_ADD_CUR;
    LOOP
    FETCH RECEIPT_DETAILS_ADD_CUR INTO RECEIPT_DETAILS_DATA(I).D_CODE,
    RECEIPT_DETAILS_DATA(I).D_NAME,
    RECEIPT_DETAILS_DATA(I).R_CODE,
    RECEIPT_DETAILS_DATA(I).R_DATE,
    RECEIPT_DETAILS_DATA(I).R_SL_NO,
    RECEIPT_DETAILS_DATA(I).M_CODE;
    EXIT WHEN RECEIPT_DETAILS_ADD_CUR%NOTFOUND;
    I:=I+1;
    END LOOP;
    CLOSE RECEIPT_DETAILS_ADD_CUR;
    END RECEIPT_DETAILS_ADD_PROC;



    PROCEDURE GEN_RECT_PROC(GEN_RECT_DATA IN OUT GEN_RECT_TABLE, DONOR_CODE_PARAM IN NUMBER, DONOR_NAME_PARAM IN VARCHAR2,RECT_DATE_PARAM IN DATE, GLOBAL_TRUST_CODE IN NUMBER, YEAR_START_PARAM IN DATE, YEAR_END_PARAM IN DATE) IS

    CURSOR GEN_RECT_CUR IS
    select r.donor_code,
    D.FIRST_NAME,
    rect_date,
    sl_no
    from receipt_register_tab r,donor_tab d,title_tab t
    where r.donor_code=d.donor_code
    and d.title_code=t.title_code
    and r.trust_code=global_trust_code
    and rect_date >=year_start_PARAM
    and rect_date <=year_END_PARAM
    AND R.DONOR_CODE LIKE DONOR_CODE_PARAM||'%'
    AND UPPER(D.FIRST_NAME) LIKE DONOR_NAME_PARAM||'%'
    AND UPPER(RECT_DATE) LIKE RECT_DATE_PARAM||'%'
    order by R.DONOR_CODE, rect_date desc,sl_no;

    I BINARY_INTEGER := 1;
    BEGIN

    OPEN GEN_RECT_CUR;
    LOOP
    FETCH GEN_RECT_CUR INTO GEN_RECT_DATA(I).D_CODE,
    GEN_RECT_DATA(I).D_NAME,
    GEN_RECT_DATA(I).R_DATE,
    GEN_RECT_DATA(I).R_SL_NO;

    EXIT WHEN GEN_RECT_CUR%NOTFOUND;
    I:= I+ 1;
    END LOOP;

    CLOSE GEN_RECT_CUR;

    END GEN_RECT_PROC;


    END GOODNEWS_PKG;

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Assuming that this form is supposed to be run on MS Windows using Internet Explorer, I'd say that PREVIOUS version of this form was open in an IE window. Then you returned to Forms Builder, changed something and tried to run the same form again, but it wouldn't work.

    Would it help if you close previous form instance (i.e. the IE window)?
    Also, you might try to shut OC4J instance down and start it up again prior to executing the form.

  3. #3
    Join Date
    May 2004
    Location
    BA [ARG]
    Posts
    137
    If you have no compilation errors and you can successfully save gen_rect.fmb file but you can't compile the gen_rect.fmx file, then you have a locking issue on the file, that means somebody is using it.

    If you're using webforms, restart OC4J instance like Littlefoot suggests.
    If you're using a client/server version, then somebody must be using that form.

Posting Permissions

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