Re: Using InterConnect to push data from one Oracle DB to another

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 Sat Dec 21 2002 - 06:01:41 CST