
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
Hi all,
I use in a function, that index-fields of a table determines, the following
cursor:
...
...
DECLARE
CURSOR indfields
IS
SELECT TABLE_NAME, SUBSTR (column_name, 1, 20) COLUMN_NAME
FROM all_ind_columns
WHERE index_name = vsobj and index_owner=USER
ORDER BY column_position;
BEGIN
....
.....
OPEN indfields;
LOOP
FETCH indfields
INTO sTable, sfields;
EXIT WHEN indfields%NOTFOUND;
if I use instead of all_ind_columns user_ind_columns - everything is ok.
Now I would like to create the function in one user and to make it for
different user available with public synonym. Therefore I am changed on
all_ind_columns.
Now the function runs only in the user correctly where it was created.
In any other user I get immediately indfields%NOTFOUND.
Does someone have an idea?
Thanks in advance
Andrei
| <-- __Chronological__ --> | <-- __Thread__ --> |