Calling Stored procedure within the Orcale Server or outside client

A

aadilnw

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
 
?

=?ISO-8859-1?Q?Arne_Vajh=F8j?=

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top