Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!newsfeed.berkeley.edu!ucberkeley!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Ron Reidy Newsgroups: comp.databases.oracle.tools Subject: Re: how to send message back to a calling c++ program from with Oracle PL/SQL on the fly? Date: Thu, 06 Jun 2002 08:30:15 -0600 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <3CFF71F7.2797DE13@indra.com> X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: newsabuse@supernews.com Lines: 16 Xref: easynews comp.databases.oracle.tools:51679 X-Received-Date: Thu, 06 Jun 2002 07:33:38 MST (news.easynews.com) hongen wrote: > > Hi ALL. I am writing a C++ program daily_update, which does daily > database update,summerization etc. One thread of daily_update calls a > Oracle stored procedure (update_pro) every midnight to do a table > update and daily_update continue its other jobs without waiting for > update_pro to finish. The problems is that daily_update don't know > wether or not update_pro succeed. Is there a way for update_pro to > send a message (success or fail) back to daily_update on the fly? > Thanks in advance. Hongen Yes, Think sockets or setting a value in a table. Also think AQ. -- Ron Reidy Oracle DBA