Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

all_ind_columns in stored procedure



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__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.