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