1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Pl sql 7203 nocopy compiler hint

Discussion in 'SQL PL/SQL' started by mirza, Aug 5, 2009.

  1. mirza

    mirza Active Member

    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    80
    Dear Friendz,

    My devlopers are getting the following warning when they are compiling a procedure:-

    PL SQL 7203 NOCOPY COMPILER HINT

    Please Help

    Thanks
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO

    Apparently that is NOT a complete error message as it should state the following:

    PLS-07203 "parameter '%s' may benefit from use of the NOCOPY compiler hint"

    So now one wonders which parameter is throwing this warning. You'll need to provide much more information than you have if you want a satisfactory answer.
     
    mirza likes this.