PLW-07203: parameter 'string' may benefit from use of the
NOCOPY compiler hint
Answer / guest
Cause: The mode of the specified parameter was IN OUT or
OUT. Use of the NOCOPY compiler hint may speed up calls to
this subprogram.
Action: Change the mode of the parameter to explicitly use
the NOCOPY compiler hint. For example, if your subprogram
declaration is: PROCEDURE proc(p1 IN OUT CLOB); you can
change it to: PROCEDURE proc(p1 IN OUT NOCOPY clob); to get
the benefit of the NOCOPY hint. For member procedures or
functions in object types, you may have to explicitly
declare the SELF parameter as illustrated in the following:
MEMBER PROCEDURE proc(SELF IN OUT NOCOPY MY_TYPE);
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
PLS-00260: Datetime/Interval constraints must be in range (0 .. 9)
DRG-11862: This Is Probaly A HTTP Server 0.9 Or Less
ORA-14162: subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
ORA-12840: cannot access a remote table after parallel/insert direct load txn
ORA-01268: invalid TEMPFILE clause for alter of permanent TABLESPACE
DRG-11704: phrase string does not exist
ORA-00075: process "string" not found in this instance
CLSR-00002: Oracle error encountered while executing string
PLS-00172: string literal too long
ORA-30027: Undo quota violation - failed to get string (bytes)
ORA-01184: logfile group string already exists
ORA-12703: this character set conversion is not supported