Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ProC vs. Stored Procedure
I have been told that there is no advantage to using a stored procedure vs. coding SQL directly in my C++ application. The source says that Oracle will only compile the SQL the first time it sees it. Is this true or will I get better performance from a stored procedure? Why? What Oracle documentation should I review?
Thanks
Tom Groszko
Received on Tue Sep 23 1997 - 00:00:00 CDT