Triger调用存储过程 [英] Triger Calls Stored Procedure

问题描述

我有1个问题触发器如何调用存储过程..

就像我有触发器计算somthing和我有程序，如果有这样的名称，它将总结它，如果没有将有是新记录

所以我想触发调用存储过程你能给我一些代码

解决方案

我建​​议你阅读一些关于触发器的教程基础知识和执行时，以及用于创建它们的语法。

这是PL SQL教程的示例，我用它来学习它非常好：

http://www.tutorialspoint.com/plsql/plsql_triggers.htm [ ^ ]

因此调用内部触发器的过程很简单，你只需编写为1 line语句就像任何其他的，过程名称和输入参数（如果有的话）就是这样。

希望我能帮助。

I have 1 quesiton How Trigger can Call Stored procedure ..
like i have trigger that calculating somthing and i have procedure that cheks if there is name like that it will sum it if not there will be new record
so i want to trigger call stored procedure can you give me some code

解决方案

I suggest you read some tutorial on triggers basics and when they execute, and syntax used to create them.
This is example for PL SQL tutorial, very good one i used it to learn it:
http://www.tutorialspoint.com/plsql/plsql_triggers.htm[^]
So calling procedure inside trigger is simple, you just write is as 1 line statement like any other, procedure name and input parameters if any and that's it.
Hope I helped.

这篇关于Triger调用存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！