Connect to an external data system using a socket and propagate data changes using a trigger... I've had to do this, and it sucks to be stuck in Oracle!
Alex Turner NetEconomist On Mon, 10 Jan 2005 17:29:52 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > On Mon, Jan 10, 2005 at 12:46:01PM -0500, Alex Turner wrote: > > You sir are correct! You can't use perl in MS-SQL or Oracle ;). > > On the other hand, PL/SQL is incredibly powerful, especially combined > with all the tools/utilities that come with Oracle. I think you'd be > hard-pressed to find too many real-world examples where you could do > something with a PostgreSQL procedural language that you couldn't do > with PL/SQL. > -- > Jim C. Nasby, Database Consultant [EMAIL PROTECTED] > Give your computer some brain candy! www.distributed.net Team #1828 > > Windows: "Where do you want to go today?" > Linux: "Where do you want to go tomorrow?" > FreeBSD: "Are you guys coming, or what?" > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match