Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    14

    Exclamation Unanswered: error PLS-00201 while executing stored proc

    Hi , i am getting below error when calling stored procedure from java code.

    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'sp_proc' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    the stored procedure is installed in some other schema than the schema i am calling.
    i.e i am calling stored proc with username 'user1' and password 'user1'. But the procedure is installed in different schema.

    Why this exceptions is coming.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,098
    Provided Answers: 4
    As you've put it, it seems that owner has to GRANT EXECUTE (if that's all it needs) to another user in order for it to be able to run the procedure.

  3. #3
    Join Date
    Jul 2007
    Posts
    14
    Is that granting execute is Okay or the procedure is needed to installed in same schema of the user who is trying to execute

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,098
    Provided Answers: 4
    It depends on how you plan to call it; if you want to use only a procedure's name, you'll have to create a SYNONYM. Otherwise, use "owner.procedure_name" notation.

Posting Permissions

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