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 |
ORA-26077: direct path column array is not initialized
ORA-09934: Link of current password file to old failed.
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
ORA-01951: ROLE 'string' not granted to 'string'
ORA-19762: invalid file type string
TNS-12196: TNS:received an error from TNS
RMAN-08537: channel string: skipped, autobackup already found
ORA-07281: slsget: times error, unable to get cpu time.
ORA-09819: Number exceeds maximum legal value
ORA-12590: TNS:no I/O buffer
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=string
ORA-32810: foreign queue string is not registered