1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-01403: no data found

Discussion in 'SQL PL/SQL' started by pradeep84, Oct 28, 2008.

  1. pradeep84

    pradeep84 Active Member

    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    80
    Hi guys,

    I am getting error while executing

    Code (Text):

    SQL> BEGIN
    2 DBMS_REPCAT.ADD_UNIQUE_RESOLUTION (
    3 sname => 'repuser',
    4 oname => 'name',
    5 constraint_name => 'NAME_EMAIL_UK',
    6 sequence_no => 2,
    7 method => 'APPEND SITE NAME',
    8 comment => 'Append site name',
    9 parameter_column_name => 'email');
    10 END;
    11 /
    BEGIN
    *
    ERROR at line 1:
    ORA-01403: no data found
    ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 814
    ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 1559
    ORA-06512: at "SYS.DBMS_REPCAT", line 261
    ORA-06512: at line 2
     
    Any suggestions?
     
  2. Arju

    Arju Forum Expert

    Messages:
    107
    Likes Received:
    5
    Trophy Points:
    240
    Location:
    Bangladesh
    Possibly your problem is case sensitivity.

    Whenever you provide any text within quote then by default it is the case within the quote. So
    Both termed as lower case. But I think when you created those schema name and user you created in upper case. So provide as,
    Code (Text):
    3 sname => 'REPUSER',
    4 oname => 'NAME'