|
Calling a PL/SQL procedure is really a function of
your application, just as it is in SQL Server. If I am
in SQL*Plus, then I can call any procedure as follows:
EXEC proc_name;
If I am in a PL/SQL block, I can call the stored
procedure as follows:
proc_name;
It doesn't get any simpler than that!
For some additional examples, let's suppose that my
application is a Java Server Page (JSP). Then, I can
call a stored procedure with the following JSP code:
<%
CallableStatement cstmtMyProc =
ConncstmtMyProc.prepareCall("{call myProc}");
cstmtMyProc.execute();
%>
Hopefully, you've gotten the idea that calling a
stored procedure varies depending on the application
platform you are using. This is true of any RDBMS
engine, including SQL Server and Oracle.
For More Information
|
