帆软8.0怎么调用oracle中的管道函数

Question

如题所述

Answer 1

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};