Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing connection to stored procedure

Re: Passing connection to stored procedure

From: sybrandb <sybrandb_at_gmail.com>
Date: 30 Mar 2007 05:34:49 -0700
Message-ID: <1175258089.521694.221610@n76g2000hsh.googlegroups.com>


On Mar 30, 2:20 pm, "aadil" <aadi..._at_gmail.com> wrote:
> Hi all,
>
> I am doing the database purging. In which i have two different
> database servers one used as Main database server and other as history
> database server. My stored procedures are on the main server. Right
> now iam doing purging using DBLINK concept. Is there any other way to
> do it.
> Like passing connections directly to stored procedures or using Java
> stored procedures.
>
> Thanks,

Why don't you use dbms_job in each database? Doing so your client is freed, and you are available for other, more useful tasks.

--
Sybrand Bakker
Senior Oracle DBA
Received on Fri Mar 30 2007 - 07:34:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US