-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|