Originally posted by Carl Trusiak:
First of all, I have to ask ... Why? If the procedure can be done in PLSQL, then 90% of the time, that's the most efficient way to perform the function.
Carl is the reason why PL/SQL stored procedures more efficient than java stored procedures because they are loaded into memory? The CBT's I am learning Oracle from keep saying the PL/SQL procedures are the most efficient, but they do not explain why.
Sorry for butting in Rajah.