Re: problems with Oracle stored procedure

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Jul 09 2007 - 13:14:51 EDT

  • Next message: Bryan Lewis: "Re: problems with Oracle stored procedure"

    Hi Greg,

    Unfortunately I don't have access to Oracle at present. I think I can
    tweak the OracleProcedureAction to use a bit different strategy when
    processing result set. But I can only do that if I have the test
    environment, which I don't :-/ Let me see if I can resolve the Oracle
    situation (maybe put it on a virtual Linux partition on my Mac... ).
    In the meantime if you find anything of relevance, please share.

    Andrus

    On Jul 9, 2007, at 7:45 PM, Greg Boshart wrote:
    > After further testing, I wrote a do-nothing stored procedure in
    > Oracle:
    >
    > CREATE OR REPLACE PROCEDURE skeleton
    > IS
    > BEGIN
    > DBMS_OUTPUT.PUT_LINE('Hello World!');
    > END;
    > /
    >
    > This procedure runs fine via JDBC but once again gets stuck in an
    > endless loop in Cayenne. I have verified this behavior in Solaris
    > 9 and
    > Windows 2003 environments.
    >
    > Thanks,
    >
    > Greg
    >
    > ________________________________
    >
    > From: Greg Boshart
    > Sent: Monday, July 09, 2007 8:24 AM
    > To: use..ayenne.apache.org
    > Subject: RE: problems with Oracle stored procedure
    >
    >
    > I appreciate the response. It turns out there was already no adapter
    > specified. Any other ideas?
    >
    > Thanks,
    >
    > Greg
    >
    > ________________________________
    >
    >
    > This sounds very similar to a problem I had last year. I got an
    > infinite loop of "updated rows" log messages on Oracle. See
    > CAY-464 at
    > https://issues.apache.org/cayenne/browse/CAY-464
    > <https://issues.apache.org/cayenne/browse/CAY-464>
    >
    > Maybe it won't help -- we thought the problem appeared only on an
    > older
    > version of Oracle -- but it's worth a try. Clear the Custom Adapter
    > fields in the modeler.
    >



    This archive was generated by hypermail 2.0.0 : Mon Jul 09 2007 - 13:15:18 EDT