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!

How to review implication of database character set change on PL/SQL code?

Discussion in 'General' started by grashmi13, Sep 15, 2013.

  1. grashmi13

    grashmi13 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi,



    We are converting WE8ISO8859P1 oracle db characterset to AL32UTF8. Before conversion, i want to check implication on PL/SQL code for byte based SQL functions.

    What all points to consider while checking implications on PL/SQL code?

    I could find 3 methods on google surfing, SUBSTRB, LENGTHB, INSTRB. What do I check if these methods are used in PL/SQL code?

    What all other methods should I check?
    What do I check in PL/SQL if varchar and char type declarations exist in code?
    How do i check implication of database characterset change to AL32UTF8 for byte bases SQL function.


    Thanks in Advance.

    Regards,
    Rashmi
     
  2. grashmi13

    grashmi13 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    My PL/SQL code uses SUBSTR, LENGTH functions. Could these methods need change on database character set change to AL32UTF8?