Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

warnings in stored procedure

833676Feb 17 2011 — edited Feb 17 2011
i am new to oracle i am writing a stored procedure of about 1600 lines when i compiled the stored procedure
it is giving me warnings AND not any error and got compiled successfully which i write below

warnings
Warning(6,2): PLW-07203: parameter 'P_RN' may benefit from use of the NOCOPY compiler hint
Warning(168,72): PLW-07204: conversion away from column type may result in sub-optimal query plan
Warning(169,48): PLW-07204: conversion away from column type may result in sub-optimal query plan
.
.
.
.
.
.
.
.
.
.
Warning(1,1): Only first 20 issues are reported -- coming at last


and when check the status of the stored procedure by running the below query
informing that object is INVALID
select status from all_objects where object_name='USP_GENERATERUNNINGNUMBER';

and as far as i know that if warnings come and no error then it means procedure has been
compiled successfully and becomes VALID

please help me somebody
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2011
Added on Feb 17 2011
3 comments
258 views