#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:(

     
  • Aleksey Kochetov

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

     
  • Aleksey Kochetov

    • status: open --> closed-rejected
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks