Supported features when using Oracle stored procedures – PB Docs 126

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 Chapter 10, “Using Oracle.”


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x