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

[Anonymous]

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 ...).

[Drzewiecki T.]

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.]

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