another PLS-00201

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • windos
    #1

    another PLS-00201


    Guys,

    I'm newbie here and tryin to create a simple procedure :
    ----
    CREATE OR REPLACE PROCEDURE update_status IS
    CURSOR cekstat is
    select b.CREATOR_PROC_ INST_ID,
    b.MANAGED_FILE_ ID,
    d.JOB_STATUS
    from other.rejproces slog a,
    admin.managedfi le b,
    admin.jobhasfil e c,
    admin.job d
    where a.FILE_STATUS_I D=0
    and a.TO_DETIL_STAT =0
    and b.CREATOR_PROC_ INST_ID=a.PROCE SS_ID
    and b.MANAGED_FILE_ ID=a.MANAGED_FI LE_ID
    and c.MANAGED_FILE_ ID=b.MANAGED_FI LE_ID
    and d.JOB_ID=c.JOB_ ID
    for update;
    BEGIN
    FOR rec in cekstat
    LOOP
    update rejprocesslog
    set rejprocesslog.F ILE_STATUS_ID=c ekstat.JOB_STAT US
    where rejprocesslog.M ANAGED_FILE_ID= cekstat.MANAGED _FILE_ID;
    END LOOP;
    COMMIT;
    END update_status;
    /
    --
    But i got this error : PLS-00201: identifier 'ADMIN.MANAGEDF ILE' must
    be declared.
    I've red couple of message like this posted in dbforums, but still i had
    the same error. the MANAGEDFILE,JOB and JOBHASFILE tables are already
    have synonims.

    Is there any ideas for this problems ??

    thank you.

    rgds,
    windos

    --
    -


    Posted via http://dbforums.com
    Tags: None
    • Guido Konsolke
      #2
      Re: another PLS-00201

      "windos" <windosab@yahoo .comschrieb im Newsbeitrag
      news:3145998.10 59012752@dbforu ms.com...
      >
      Guys,
      >
      I'm newbie here and tryin to create a simple procedure :
      ----
      CREATE OR REPLACE PROCEDURE update_status IS
      CURSOR cekstat is
      select b.CREATOR_PROC_ INST_ID,
      b.MANAGED_FILE_ ID,
      d.JOB_STATUS
      from other.rejproces slog a,
      admin.managedfi le b,
      admin.jobhasfil e c,
      admin.job d
      where a.FILE_STATUS_I D=0
      and a.TO_DETIL_STAT =0
      and b.CREATOR_PROC_ INST_ID=a.PROCE SS_ID
      and b.MANAGED_FILE_ ID=a.MANAGED_FI LE_ID
      and c.MANAGED_FILE_ ID=b.MANAGED_FI LE_ID
      and d.JOB_ID=c.JOB_ ID
      for update;
      BEGIN
      FOR rec in cekstat
      LOOP
      update rejprocesslog
      set rejprocesslog.F ILE_STATUS_ID=c ekstat.JOB_STAT US
      where rejprocesslog.M ANAGED_FILE_ID= cekstat.MANAGED _FILE_ID;
      END LOOP;
      COMMIT;
      END update_status;
      /
      --
      But i got this error : PLS-00201: identifier 'ADMIN.MANAGEDF ILE'
      must
      be declared.
      I've red couple of message like this posted in dbforums, but still i
      had
      the same error. the MANAGEDFILE,JOB and JOBHASFILE tables are
      already
      have synonims.
      >
      Is there any ideas for this problems ??
      >
      thank you.
      >
      rgds,
      windos
      >
      --
      -
      Windos,

      1. If there are synonyms, why don't you use it.
      2. You mention you read about the PLS-00201,
      did you check privileges)

      rgds,
      Guido


        Comment

        Previous template Next
        Working...