如何在数据库PL / SQl中创建存储过程 [英] how to create store procedure in database PL/SQl
问题描述
创建或替换程序SP_SPAN_JV_NSEC_IMP(
sCODE IN VARCHAR2,
VARCLAR2中的sCLIENTNAME,
sCash_Deposits在FLOAT,
sCollateral_I在FLOAT,
sCOLLATERAL_II在FLOAT,
sPERSONAL_POA在FLOAT,
sTOTAL_MARGIN在FLOAT ,
sSPAN_MARGIN在FLOAT,
sMARGIN_VIOLATION在FLOAT,
sMTM_TOTAL在FLOAT,
sFINANCE_DR在FLOAT,<浮动,
sFINANCE_CR FLOAT,
sFREE_COLLATERAL_CASH浮动,
sNET_REC_PAY浮动,
sCASH_SHORTAGE FLOAT,>
在FLOAT中的sCOLLATERAL_SHORTAGE,
nEXIM_ID在数字中
)
但是参数显示没有任何东西,并在程序上给出了红色标记。
程序。 php [ ^ ]
plsql-procedures.htm [ ^ ]
希望它会帮你..
嗨...
看到这个,可能对你有帮助。
CREATE DEFINER =`root` @`localhost` PROCEDURE `insert`( 名称 varchar ( 45 ),> 电子邮件 varchar ( 45 ),in add1 varchar ( 45 ),中的class =code-keyword> add2 varchar ( 45 ), phno varchar ( 45 ))
BEGIN
insert into ` databasename` .procedurename`(name,email_id,address1,address2,phone_no) values (name,email,add1,add2,phno);
END
谢谢你。
一般语法创建程序是:
CREATE [OR REPLACE] PROCEDURE proc_name [参数列表]
IS
声明部分
BEGIN
执行部分
EXCEPTION
例外部分
END ;
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.
procedures.php[^]
plsql-procedures.htm[^]
Hope it will help you..
Hi...
See this, may its help ful to u.
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.
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;
这篇关于如何在数据库PL / SQl中创建存储过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!