Experiencing problem with "post" packaged Pro.

From: Farzin Shakibanejad <farzin_at_bwcbwc.org>
Date: 23 Aug 93 06:40:28 GMT
Message-ID: <10155_at_bwc.BWC.ORG>

This is message was posted few days ago. Once more I need to post it since I assume it did not 'really' heppen ! Farzin

Experiencing problem with "post" packaged procedure in FORMS 3.0 and locking.

---

Hardware/Software:
SunOs 4.1.3 (unix) / Oracle 7.0.12.1.0 / sqlforms30 3.0.16.12.3

I have encountered a problem which has to do with table locking and is explained by the following example.

Considering the following two tables: (to be created under scott/tiger)

CREATE TABLE MGRS (

 MGRNO               NUMBER(4),
 MGRNAME             VARCHAR2(20),

 CONSTRAINT MGRS_PRIMARY_KEY PRIMARY KEY (MGRNO)); CREATE TABLE EMPS (

 EMPNO               NUMBER(4) NOT NULL,
 ENAME               VARCHAR2(20),
 MGR                 NUMBER(4) CONSTRAINT EMPS_MGR_KEY
                               REFERENCES MGRS (MGRNO),

 CONSTRAINT EMPS_PRIMARY_KEY PRIMARY KEY (EMPNO)); And supposing we have one form (form 3.0) build on top of these tables called emp_form.frm

User A calls the form by issuing "iap30 emp_form scott/tiger" and does the following

• modifies and/or creates a record on emps block
• "POST" it via firing a trigger and using package procedure: post; (No COMMIT)

the following message on the banner appears: (which is fine) FRM-40404: Database posting complete -- 1 record posted.

now leave this form running without doing anything else and go to the user B.

user B calls the same forms and modifies / creates a record on the MGR block. Upon pressing a key to "POST" or "COMMIT" the modified data, "working...." appears on the banner and stays so until user A presses "COMMIT" to commit the posted records.

Why does this behave this way? I do need to do something so user B can post and go on until such time that user A and/or B decide to commit and/or rollback everything that is posted in it's session.

SAVEPOINTS don't work from form30 on v7.0.12 because of incompatibility between the pl/sql versions (for form30 the pl/sql version is 1.00.36.02.02 and the database has 2.0.14.0.1)

any help would be very much appreciated. Farzin

+===========================================================================+


! Farzin Shakibanejad  Data Processing Department Email: farzin_at_bwc.org     !

! Database             Baha'i World Centre               uunet!bwc!farzin   !

! Administrator        P.O. Box 155               Fax:   972.4.358-525      !


! Tel: 972(4)358358    3100 Haifa, Israel         Telex: 922-46626(BAYT IL) !


+===========================================================================+

Received on Mon Aug 23 1993 - 08:40:28 CEST