Server vs designer running stored pocedures

Article View: borland.public.intrabuilder.data.sql

Article #61

Back to borland.public.intrabuilder.data.sql Previous Next

#61

From: Robert L Israel
Date: Thu, 26 Mar 1998 00:00

19 lines
1117 bytes

We recently had a situation in which a bug in an Oracle stored procedure
(one that returns a value in a parameter) resulted in a hung session (on
the Oracle server) every time it was fired off from a form.

Whenever the form was run from an IB server, the server locked up in
what seemed like a permanent wait state and had to be shut down and
restarted. (Web server was ok)

From the IB designer this was not the case.

Is there a difference in the way agents and the designer interact with
databases?

(This is IB c/s 1.5 on Win95, Oracle 7)

Thanks in advance.

Bob

Technical Details

Message-ID: <351A9B7D.33A0@facstaff.wisc.edu>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,dc4ea9244758b36b,start
X-Google-Attributes: gid101d9a,public
From: Robert L Israel <rlisrael@facstaff.wisc.edu>
Subject: Server vs designer running stored pocedures
Date: 1998/03/26
Message-ID: <351A9B7D.33A0@facstaff.wisc.edu>
X-Deja-AN: 337968133
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: UW-Extension, Cooperative Extension/Academic
Newsgroups: borland.public.intrabuilder.data.sql