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!

Sequencing issue while migrated to 11G

Discussion in 'General' started by sampige_sbr, Jun 7, 2010.

  1. sampige_sbr

    sampige_sbr Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hello All,

    We have an application , where in the data is loaded in the Sequencing order, which is by ORDER BY CLAUSE. This was working fine in 10 G When we migrated the application from 10G to 11G, there is an issue in the ORDER BY CLAUSE, which is creating problem in uploading the data, by checking the sequence number. Has anyone faced this issue before,if so can some one help me please.

    Thanks and Regards
    rama
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You don't describe this problem so it's difficult for anyone to respond. Please describe this issue in far more detail.
     
  3. sampige_sbr

    sampige_sbr Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi

    More details of this issue.

    The records are in the folowing format

    Product-Number,Sequence-Number,Supplier-code, Effective-Date


    The Sequence-Number value is Hard coded like the serial Number like 1, 2,3, 4 etc
    Our application loads the data to the main database, in the sequential order.
    Like to load the data with the Sequence-Number 2, it checks for the availaibilty of the
    records with Sequence-Number 1, similar way to load the data with the Sequence Number 3,
    a check is done for the availability of the record with the Sequence number 2.

    Now the issue which we are facing is , even though the record with the Sequence Number 2,
    is present, this is not getting recognised and the load of the record with the Sequence Number
    3 is failing.

    The code was working fine , till we migrated this code from 10G to 11G.

    Any specific changes or considerations to be taken care from the code perspective , when we do the
    Migration.

    Please do let me know if you need any more information

    Thanks and Regards
    Rama
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Seeing the code and some sample data would be helpful.