Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013
    Posts
    4

    Unanswered: "ORA-29970: Specified registration id does not exist".

    Hi Oracle form guys,

    I am implementing the oracle database change notification mechanism in my app

    but i am getting the problem saying user does not privileges after that it's saying specified reg id does not exist.

    "ORA-29970: Specified registration id does not exist".

    if anybody have the solution please let me know.

    my env are websphere7 and oracle database.

    thanks in advance.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I'm not familiar with what you are trying to do, but here's what Oracle says (I hope you'll understand what it means):
    ORA-29970: Specified registration id does not exist

    Cause: An incorrect regid value was passed to dbms_chnf procedure.

    Action: pass the correct regid value.

  3. #3
    Join Date
    May 2013
    Posts
    4

    ORA-29970: Specified registration id does not exist

    Hi Littlefoot,

    thanks for the replay but the problem is when registering the dcn the problem was occurred.

    Statement stmt = conn.createStatement();
    ((OracleStatement) stmt).setDatabaseChangeRegistration(dcr);
    ResultSet rs = stmt.executeQuery("select * from EXAMPLE where ID=1");
    while (rs.next()) {
    }

    but still i could not able to resolve the issue. I have given the grant permissions also.

    Please anybody help me to solve this problem.

Tags for this Thread

Posting Permissions

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