error when compiling case sensitive stored procedure/package

[Zafer]

Marko,

today I tried to compile a stored package and couple of stored
procedures. The names are case sensitive such as "uRUNWAY_TGTp".

When trying to recompile the related db object in DBSolo (latest
preview, on Ubuntu 10.04 with Oracle JDK/JRE ) I am getting ORA-04043
errors - URUNWAY_TGTP object does not exist.

Apparently, DBSolo does not care case sensitivity in database object
names.

(note: in the pull down menu and object browser of the DBSolo screen,
the db objects properly shown their case sensitive names). I ended up
opening the related db objects in Oracle's SqlDeveloper and compile
them there.

Can you fix this please.

Thanx
Zafer

[Marko Hantula]

This should be fixed now, please download the latest from dbsolo.com/preview.

marko

> --
> You received this message because you are subscribed to the Google Groups "DB Solo" group.
> To post to this group, send email to db-...@googlegroups.com.
> To unsubscribe from this group, send email to db-solo+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/db-solo?hl=en.
>

[Zafer]

Marko,

the issue is not fixed in the latest preview. I downloaded and tested
as such:

1. from the Packages tab in Browser, find a package, which has a case
sensitive name. Go to that package, by double clicking in the list.

2. Click the Package Body tab - then the Source tab

3. At the bottom of the package body listing (window), click on the
"Edit in Package Editor" button

(note: it takes way too long to display the package source code in
editor - there is something wrong - that should not take that long - I
do the same thing in SqlDeveloper and it is almost immediate)

4. In the Editor screen, click on the icon (at the top left) to
compile or do CTRL+F9

you will get the error (ORA-04043: object URUNWAY_TGTP does not
exist
(the original object name is uRUNWAY_TGTp)

Hope this helps to diagnose the issue.
Cheers
Zaf

[Marko Hantula]

It was fixed in the compile dialog earlier. Now it should be fixed in
the Package Editor as well.
Please download the latest from dbsolo.com/preview.

Marko

[Zafer]

Marko,
tested the latest preview and tested. The issue is fixed.

I have noticed that when I click on the "Edit in Package Editor"
button the "very first time", then it takes way too long to display
the Editor screen. But, once the Editor screen is displayed, then you
can open any other package/trigger etc almost instantaneously. The
delay is really at the very first time the Editor screen is accessed.
Looks like the program trying to read all the database objects the
very first time instead of just accessing the specified object.

It happens every time I close the DBSolo and then re-open and then try
to access the Editor screen.

It is not a critical issue but should be addressed or at least be
investigated.

I tried it on 2 separate Linux machines, different OS - same JDK
version - enough memory allocated to DBSolo (-J-Xmx1024m) when
initiated.

Thanx for fixing the issue - the tool is getting better each time ;)
Cheers
Zaf