由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - why use anonymous block when calling stored procedure?
相关主题
SQL debug step into a store procedure from another one (转载)stored procedure 菜鸟一问, PLEASE HELP,在线等
Transact SQL问题请教Stored Procedure / Trigger - 谢谢
问一个store procedure 问题怎末优化一个stored procedure ?
Stored Procedure?请推荐关于Stored Procedure的书
如何分析Stored Procedure运行时间过长?Can I use array in SQL stored procedure?
how can i execute pl/sql (or stored procedure) in java??Help: stored procedure in oracle
[转载] intensive I/O and odbc problem问一个crystal report的问题
stored procedure help Please.....Why does this Stored procedure fail ?
相关话题的讨论汇总
话题: procedure话题: anonymous话题: block话题: why话题: stored
进入Database版参与讨论
1 (共1页)
h**********s
发帖数: 171
1
in php/perl/etc, connect to Oracle Database
why need to enclose it in an anonymous block like this?
BEGIN
//call procedure
END;
B*****g
发帖数: 34098
2
9i:
call procedure 有一些exception不能handle。有一次一个call proc一点儿error都没
显示,但是error了。加了begin end就出error了。

【在 h**********s 的大作中提到】
: in php/perl/etc, connect to Oracle Database
: why need to enclose it in an anonymous block like this?
: BEGIN
: //call procedure
: END;

y****w
发帖数: 3747
3
应该还有些变量作用范围的东东,

【在 h**********s 的大作中提到】
: in php/perl/etc, connect to Oracle Database
: why need to enclose it in an anonymous block like this?
: BEGIN
: //call procedure
: END;

1 (共1页)
进入Database版参与讨论
相关主题
Why does this Stored procedure fail ?如何分析Stored Procedure运行时间过长?
请教:how to call a COM object in a stored procedure?how can i execute pl/sql (or stored procedure) in java??
请各位帮我看看这个最简单的Stored Procedure (转载)[转载] intensive I/O and odbc problem
再请教一个问题:stored procedure能不能直接显示信息什么的? (转载)stored procedure help Please.....
SQL debug step into a store procedure from another one (转载)stored procedure 菜鸟一问, PLEASE HELP,在线等
Transact SQL问题请教Stored Procedure / Trigger - 谢谢
问一个store procedure 问题怎末优化一个stored procedure ?
Stored Procedure?请推荐关于Stored Procedure的书
相关话题的讨论汇总
话题: procedure话题: anonymous话题: block话题: why话题: stored