RE: Creating an SQL function from a service program -- MIDRANGE-L

Subject: RE: Creating an SQL function from a service program
From: dlclark@xxxxxxxxxxxxxxxx
Date: Tue, 9 Jan 2018 15:00:45 -0500
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 01/09/2018
02:57:39 PM:

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 01/09/2018
02:39:44 PM:

Question
If that is in fact the answer - does that mean that any program
using that procedure needs to be re-compiled?

Yes. Almost any change to the parameter list format requires all
callers to know about the change. About the only change that would be
transparent to the caller is adding an optional parameter to the end of
the parameter list -- which I've done without recompiling the world.

Oh, and even that would be a problem if there is a stored
procedure with other than a general parameter style using that parameter
list.

Sincerely,

Dave Clark

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.