Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    87

    Unanswered: Error while Pinning Procedure

    Hi,
    Any idea what is causing this error

    SQL> exec dbms_shared_pool.keep(CDWSTG.TCS_CDW_PROJECT_P,'P' );
    BEGIN dbms_shared_pool.keep(CDWSTG.TCS_CDW_PROJECT_P,'P' ); END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 36:
    PLS-00222: no function with name 'TCS_CDW_PROJECT_P' exists in this scope
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Error while Pinning Procedure

    You should type:

    exec dbms_shared_pool.keep('CDWSTG.TCS_CDW_PROJECT_P',' P');

  3. #3
    Join Date
    Mar 2004
    Location
    India
    Posts
    87
    Thanks!
    Is there anything I should be checking before pinning procedures/packages in the shared pool.
    x$ksmlru is not giving me the info I need for the procedures/packages I would like to pin.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •