Re: How to create a sql procedure which doesn't propagate a sql package to the remote system? -- MIDRANGE-L

Subject: Re: How to create a sql procedure which doesn't propagate a sql package to the remote system?
From: "Dsternb" <dieter.bender@xxxxxxxxxxxx>
Date: Wed, 18 Oct 2023 10:29:10 +0200
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>
Ui-outboundreport: notjunk:1;M01:P0:YOkhhWehk0Q=;xRi4wunGoI1WbRlfVxP2aYI6U8L ETkmzPafhR7vuJ6OLCCPkNOS8WzC/8duNoYMnoSMpEg5NjkfdpH49NSNslqbsUQk254Gro0HC z3e4wqHFfDJdoEfhn14rpKuf40PqYfAAPxHZ7AGZnuHj7CmZ63b7r4UuhYXYEaGYNh/z2RO2B 6hPi9Yf4eVcBaKDvmLzm+40uBXXQ2s5S/NwnizD/Uw/5mv/kiVTbO8pIf8fXvEY3BLi75e1z2 x5diyldDLvPqJkzrTzKKIJSZg8qDycEHnPIRZPVTn9RtbODQ6w40+SZ1z7sy4njtAaLzrwpZW J0ogg83tqjVzyn5+OPJeteNrcD9CXZVgI4SQ7LUxqo23FVAtpKCUoRKo6wc9SFzoO5rR49Btg WOSLWXgUoi5ayH1fvZF3E/jEXnix/UWC7SDlcbvTa/zxHBPRG6gRGLgwZYuQJ9jcP6S98804M 8eb3xccoYfpeLSKtcgSuR3J8Z1ZYNSyoBIklIE3cW7LimFuu82isnQu12ihTT+37G0xk5xj8q VdsmHuZE774UNIoMrJWBfKVwlr7lemHoA7SXPk3Xyka8fa6y0j0KqiM/U0bG50VVq1k7ymVlO qWkanwprdwXn/HN8U91j3AZoYqbJ52DqexmTMqYk3zzvD/MZ5q+1KngDdhC64P+hcqBRAz38s JoxsuB+zMS6+3gk1AVbnoV205VJAOZlWEtRSCxmntw/KiFnrkdE1bcJpMTCy6tUZCnecwTki7 0VhoohEgi1hNknxWGD/mv49uSB9eYdQBYuYemmsAwGkl9Hd+Icqa0Aml+6W5aTGzzqdzSDBiM vJjv0R4/AgZAzdMtkXsSpvCBomAPtcNyeRfVqspJS50ChGf+C80bQ1LtCIrj3LF2BpA/pwRcZ DdMp6bMaJi6gLdQ==

... SQL create procedure generates a C programm with embedded SQL and this needs a package on the remote system. There is no option to avoid recreation of the package after changing the programm.
Maybe you could try to split the local and the remote part to minimize the changes to the remote part and make a SQL call from the local to the remote part.
Another option would be a local programm (in another language) using SQL CLI for the remote database operations. SQL call level interface doesn't use packages.

D*B

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2025 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.