请教pb中调用oracle 函数和过程
答案:1 悬赏:0 手机版
解决时间 2021-11-08 22:56
- 提问者网友：两耳就是菩提
- 2021-11-08 14:33
请教pb中调用oracle 函数和过程
最佳答案
- 五星知识达人网友：舍身薄凉客
- 2021-11-08 15:38
oracle写好的函数可以在SQL语句中直接调用，比如：你写了一个TRIM函数，然后PB端的SQL中可以这样调用：select col1,... from tab_name where trim(col1) ='';
进行存储过程调用:
PowerBuilder requires a declarative statement to identify the database stored procedure that is being used and a logical name that can be referenced in subsequent SQL statements. The general syntax for declaring a procedure is:
DECLARE logical_procedure_name PROCEDURE FOR
Oracle_procedure_name(:InParam1,:InParam2, ...)
{USING transaction_object};
进行存储过程调用:
PowerBuilder requires a declarative statement to identify the database stored procedure that is being used and a logical name that can be referenced in subsequent SQL statements. The general syntax for declaring a procedure is:
DECLARE logical_procedure_name PROCEDURE FOR
Oracle_procedure_name(:InParam1,:InParam2, ...)
{USING transaction_object};
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯