DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Compilation error

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    Compilation error

    when i am trying to execute the package i am getting this error,
    the tables are located in another user and i granted select privilige to
    GUEST_TRACKER_APP.


    Errors for PACKAGE BODY GUEST_TRACKER_APP.PKG_INTERFACE_INFO:

    19/1 PL/SQL: SQL Statement ignored

    20/60 PL/SQL: ORA-00942: table or view does not exist

    31/8 PLS-00341: declaration of cursor 'GET_NON_STANDARD_SHOW_INFO_CUR'

    is incomplete or malformed



    32/1 PL/SQL: SQL Statement ignored

    33/60 PL/SQL: ORA-00942: table or view does not exist

    53/35 PL/SQL: Item ignored

    76/2 PL/SQL: Statement ignored

    76/37 PLS-00364: loop index variable 'GET_NON_STANDARD_SHOW_INFO_REC'

    use is invalid



    77/2 PL/SQL: Statement ignored

    77/39 PLS-00364: loop index variable 'GET_NON_STANDARD_SHOW_INFO_REC'

    use is invalid



    78/2 PL/SQL: Statement ignored

    78/39 PLS-00364: loop index variable 'GET_NON_STANDARD_SHOW_INFO_REC'

    use is invalid



    79/2 PL/SQL: Statement ignored

    79/37 PLS-00364: loop index variable 'GET_NON_STANDARD_SHOW_INFO_REC'

    use is invalid



    80/2 PL/SQL: Statement ignored

    80/39 PLS-00364: loop index variable 'GET_NON_STANDARD_SHOW_INFO_REC'

    use is invalid

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Is there any problem with the cursor variable or any privilige problem, because the tables are owner by another user and the client need to create the package under another user.
    All the tables,indexes are valid.

Posting Permissions

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


Click Here to Expand Forum to Full Width