how to create store procedure in database PL/SQl

Question

1.00/5 (1 vote)

See more:

CREATE or Replace PROCEDURE SP_SPAN_JV_NSEC_IMP (

sCODE IN VARCHAR2,
sCLIENTNAME IN VARCHAR2,
sCash_Deposits IN FLOAT,
sCollateral_I IN FLOAT,
sCOLLATERAL_II IN FLOAT,
sPERSONAL_POA IN FLOAT,
sTOTAL_MARGIN IN FLOAT,
sSPAN_MARGIN IN FLOAT,
sMARGIN_VIOLATION IN FLOAT,
sMTM_TOTAL IN FLOAT,
sFINANCE_DR IN FLOAT,
sFINANCE_CR IN FLOAT,
sFREE_COLLATERAL_CASH IN FLOAT,
sNET_REC_PAY IN FLOAT,
sCASH_SHORTAGE IN FLOAT,
sCOLLATERAL_SHORTAGE IN FLOAT,
nEXIM_ID IN NUMBER

)

but in parameters it showing nothing and gives red mark on procedure.

Posted 2-Sep-13 21:05pm

Member 9410081

Add a Solution

Comments

Prasad Khandekar 3-Sep-13 2:19am

Hello,

Please check this documentation (http://docs.oracle.com/cd/B28359_01/appdev.111/b28843/tdddg_procedures.htm).

Regards,

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TheUltimateDebugger · Answer 1 · 2013-09-02T21:18:00

Solution 1

procedures.php[^]

plsql-procedures.htm[^]

Hope it will help you..

Posted 2-Sep-13 21:18pm

TheUltimateDebugger

Murali0195 · Answer 2 · 2013-09-03T03:10:00

Hi...
See this, may its help ful to u.

SQL

CREATE DEFINER=`root`@`localhost` PROCEDURE `insert`(in name varchar(45),in email varchar(45),in add1 varchar(45),in add2 varchar(45),in phno varchar(45))
BEGIN
insert into `databasename`.`procedurename`(name ,email_id,address1,address2,phone_no) values(name,email,add1,add2,phno);
END

Thank u.

Vivek Thanki · Answer 3 · 2013-09-03T03:32:00

Solution 3

General Syntax to create a procedure is:

CREATE [OR REPLACE] PROCEDURE proc_name [list of parameters]
IS
Declaration section
BEGIN
Execution section
EXCEPTION
Exception section
END;

Posted 3-Sep-13 3:32am

Vivek Thanki

how to create store procedure in database PL/SQl

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

how to create store procedure in database PL/SQl

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us