Supported features when using Oracle stored procedures – PB Docs 2017

Supported features when using
Oracle stored procedures

Supported features with RPCFUNC
keyword

The following are supported and unsupported Oracle PL/SQL features
when you use the RPCFUNC keyword to declare the stored procedure:

You can	You cannot
Use IN, OUT, and IN OUT parameters	Pass and return records
Use an unlimited number of parameters
Overload procedures
Pass and return PowerScript arrays (PL/SQL tables)
Use function return codes
Use blobs up to 32,512 bytes long as parameters

Supported features with DECLARE Procedure
statement

The following are supported and unsupported Oracle PL/SQL features
when you use the DECLARE Procedure statement:

You can	You cannot
Use IN and OUT parameters	Use IN OUT parameters
Use up to 256 parameters	Pass and return records
	Use more than 256 parameters
	Pass and return PowerScript arrays (PL/SQL tables)
	Overload procedures

For an example that uses a REF CURSOR variable of type IN OUT, see
Using Oracle

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2017

August 20, 2023

Was this article helpful?