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
