Calling Stored procedure within the Orcale Server or outside client

Thread view:

aadilnw@gmail.com - 29 Mar 2007 06:21 GMT

Hi all,

I have liitle confusion about the stored procedures. I am doing the
Database purging using stored procedures in Oracle 9g. can you tell is
it better to call stored procedures from outside client which i will
take care of the flow in which stored procedues are called or call it
from JAVA STORED PROCEDURS loaded in the database, which will take
care of flow in which stored procs will get executed which inturn is
set by UNIX CRON

Reply to this Message

Arne Vajhøj - 05 Apr 2007 02:10 GMT

> I have liitle confusion about the stored procedures. I am doing the
> Database purging using stored procedures in Oracle 9g. can you tell is
[quoted text clipped - 3 lines]
> care of flow in which stored procs will get executed which inturn is
> set by UNIX CRON

I do not think there are any big difference on whether the controlling
Java code is external or internal.

Performance may be slightly better if it is internal.

Arne

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...