在pb8.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};