Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using InterConnect to push data from one Oracle DB to another
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 Mon Dec 23 2002 - 17:54:05 CST