#1 Mixed-case object's names - extracting problem

Future
closed-rejected
nobody
SQL (23)
3
2011-10-05
2004-12-04
Anonymous
No

I'm trying to set up CVS using SQLTools and Toad (only
packages).
When I compared extracted sources I notice, that
SQLTools can't extract oryginal object name capitalization.

For example:
I have function 'IS_Number'. In the SQLTools I can only
extract 'IS_NUMBER' or 'is_number' (with DDL option
'Lowercase ...).

Discussion

  • Drzewiecki T.
    Drzewiecki T.
    2004-12-04

    • priority: 5 --> 6
     
  • Drzewiecki T.
    Drzewiecki T.
    2005-01-11

    • milestone: --> 455736
     
  • Drzewiecki T.
    Drzewiecki T.
    2005-06-10

    Logged In: YES
    user_id=747155

    Problem is much more complicated, than I thought.

    Currently we do the following statement:
    SELECT /*+RULE*/
    owner,trigger_name,table_owner,table_name,referencing_nam
    es,when_clause,description,trigger_body,status FROM
    all_triggers WHERE owner = :owner AND table_name IS NOT
    NULL AND trigger_name = :name

    Neither in 'trigger_name' or even 'description' there isn't proper
    (mixed case) name.
    The only place where there is OK is table: USER_SOURCE
    (ALL_SOURCE), but it will require rebuilding the whole parser!

     
  • Drzewiecki T.
    Drzewiecki T.
    2005-06-10

    • priority: 6 --> 3
    • milestone: 455736 --> Future
     
  • Drzewiecki T.
    Drzewiecki T.
    2005-06-13

    • summary: Extracting BIG problem --> Extracting problem with mixed-case object's names
     
  • Drzewiecki T.
    Drzewiecki T.
    2005-06-14

    • summary: Extracting problem with mixed-case object's names --> Mixed-case object's names - extracting problem
     
  • Drzewiecki T.
    Drzewiecki T.
    2005-06-17

    Logged In: YES
    user_id=747155

    I checked availability of TRIGGERS in ALL_SOURCE on
    different databases:
    SELECT DISTINCT type FROM all_source

    8.1.7.4.1:
    On 8i there are ():
    FUNCTION
    JAVA SOURCE
    PACKAGE
    PACKAGE BODY
    PROCEDURE

    9.2.0.4.0:
    FUNCTION
    JAVA SOURCE
    PACKAGE
    PACKAGE BODY
    PROCEDURE
    TRIGGER
    TYPE
    TYPE BODY

    And the latest 10.1.0.4.0:
    FUNCTION
    JAVA SOURCE
    PACKAGE
    PACKAGE BODY
    PROCEDURE
    TRIGGER
    TYPE
    TYPE BODY

    On 8i there aren't triggers in this view:(

     
  • sorry, it is rather a "feature" than a bug

     
    • status: open --> closed-rejected