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 |
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.”
