Re: Using InterConnect to push data from one Oracle DB to another
From: Bruce Loth <no_junk_mail_bruce.loth_at_iname.com_no_spam>
Date: Mon, 23 Dec 2002 18:54:05 -0500
Message-ID: <pe8f0v0i073036cjsb72hqmuflob38b53o_at_4ax.com>
Date: Mon, 23 Dec 2002 18:54:05 -0500
Message-ID: <pe8f0v0i073036cjsb72hqmuflob38b53o_at_4ax.com>
Frank ... many, many thanks for the info! I'll give it a try. Cheers and happy holidays.
On Sat, 21 Dec 2002 13:01:41 +0100, Frank <fbortel_at_home.nl> wrote:
>Frank wrote:
>> <snip>
>
>> In your publishing app, you should be able to do something like:
>> declare
>> msgId number;
>> aoId number;
>> begin
>> -- create the message
>> Employee.crMsg_new_employee_ICF_V1 (
>> msgId, aoId, 1234, 'Dummy', 'Frank','v',null,null,sysdate,2500,0,20
>> );
>> -- send it
>> Employee.pub_new_employee_ICF_V1(
>> msgId, 'SEND_EMP');
>> end;
>> /
>Forgot to mention - you can also code this is a on-insert
>trigger. But you had that one already firgured out, of course.
>
>Grtz, Frank
>
>
Received on Tue Dec 24 2002 - 00:54:05 CET