WebDB: Forms on Stored Procedures

From: Knut Lassmann <k.lassmann_at_q-bus.de>
Date: 1 Nov 1999 08:53:05 -0600
Message-ID: <381DA99C.2A5B02A9_at_q-bus.de>

Hi,

we have the problem, that we can't create a form on a stored procedure. Here is what we did:

1. Installed Oracle 8.0.5 on Windows NT 4.0 SP5
2. Installed WebDB 2.0.5 on the same machine
3. Connected as WebDB-User
4. Created a new site, name="test", user="test". Gave all the required rights to user "test", including WebDB-Developer and Component Building Schema.
5. Used SQL Worksheet to create a table and a stored procedure as user "test" CREATE TABLE testTable ( ID number(10), Name varchar2 (20));

        CREATE OR REPLACE PROCEDURE myTest (
                v_ID            number,
                v_Name    varchar2)
        IS
        BEGIN
                INSERT INTO testTable VALUES (v_ID, v_Name);
                COMMIT;
        END;
        /
6. Connect to the new site "test" via WebDB

7. Created a new form on the stored procedure "myTest" 8. Got the error:

        Error
Message                                           Where
         WWV-04300        Failed to execute - Create
WWV_GENERATE_UTILITIES.EXECUTE
                                           Package Body
         WWV-08300       Failed to parse as WEBDB -
WWV_PARSE.PARSE_AS_USER(IDX)
         ORA-04020         ORA-04020: deadlock
WWV_PARSE.PARSE_AS_USER(IDX)
                                           detected while trying to lock

                                           object PUBLIC.TEST

9. ??????????

We don't know what to examine to solve the problem. Any hints?

Thank you in advance

Knut

--
--------------------------------------------------------------------


|                                                                  |

|    Knut Lassmann                   Email: K.lassmann_at_q-bus.de    |

|    q~bus Mediatektur GmbH          Fon:   390 489 186            |

|    Salzufer 13F                    Fax:   390 489 140            |

|    10587 Berlin                                                  |


|                                                                  |

--------------------------------------------------------------------

Received on Mon Nov 01 1999 - 15:53:05 CET