Stored Procedures & Oracle

[tuandelia]

hello-

Can I created stored procedures in Oracle and then call them?

[MMcCarthy]

You have posted this in the articles sections rather than the forum. I am moving it over to the Oracle forum.

ADMIN

[debasisdas]

This is the basic syntax to create a procedure in oracle.

CREATE [OR REPLACE] PROCEDURE PROCEDURENAME([PARAMETER PARAMETER MODE DATATYPE [,PARAMETER...,....]])
{IS/AS}
[LOCAL DECLARATION];
BEGIN
EXECUTABLE STATMENT;
[EXCEPTION
EXCEPTION HANDLER]
END [PROCEDURENAME];

Hope that helps u out.