Re: A good challenge for gurus

Reza, I'm not surprised you're having so much trouble. Anyone trying to write serious code even non-serious code using SQL*Plus or NotePad (yes I know some people who used it once upon a time for writing Packages - foolish me included - before they discovered TOAD!) is like someone TRYING TO WALK UP A MOUNTAIN WHILE WADING THROUGH TREACLE AT THE SAME TIME. Have you tried using TOAD (TOOL FOR ORACLE APPLICATION DEVELOPERS) - it used to be only shareware (free off the web) - NOW there are 2 versions - the deluxe version from www.quest.com Quest Software (with SQLab Tuner etc.) on 30 day trial (I'll leave you to work out logistics of use if you don't buy) -and- the still available more basic (but GOOD) shareware version from www.toadsoft.com .

WHAT IS TOAD?? : TOAD is an acronym for Tool for Oracle Application Development. TOAD was begun in 1995 (by a good altruistic chap in the USA) as a personal development aid and has grown to be used daily by many thousands of developers. There are similar tools on the market, but none can better TOAD's simple developer oriented interface, the author's attention to users, or the PRICE.

So, what you must remember when evaluating TOAD or while using TOAD is that TOAD is first and foremost a developer's aid. The interface is simple by design. The features are either what I personally want in an Oracle tool or what TOAD users have requested. TOAD wasn't built on features that were "cool" or fun to implement; nor with an interface that looked "slick" since, generally, the slicker it looks, the worse it is to operate. If there is a feature that is lacking, a report that is missing, an interface implementation that is nagging, send an email to support_at_quest.com If it isn't there, it probably hasn't been requested.

If there is anyone you know writing SQL - scripts, triggers, procedures, functions or packages, sifting through tables and data, creating test data, or creating insert or update scripts, create table scripts etc... PLEASE TELL them about TOAD as TOAD will help them no end. IT JUST SAVES SO MUCH TIME! It has certainly made a huge difference to me.

HTH Joe

Reza wrote in message
<940415756.13251.0.nnrp-04.d4f07aaa_at_news.demon.co.uk>...
>Hi
>I am trying replace (CREATE OR REPLACE PACKAGE BODY ...) in 7.3.4.0
>The package is big ( maybe 5000 lines). SQL*plus says "PACKAGE CREATED
>SUCCESSFULLY" and obviously no errors. The time stamp (Last modified) on
the
>package shows that it has just been modified BUT the code changes is not
>there (looking into the source code of the package in the server.
>Please don't tell me that I'm compiling an old code,I have done it three
times.
>I think it is a problem with memory allocation in SGA (shared pool) to
>compile the package, but why it does not signal ora- 4031 ??
>I am compiling the package when the system is open and busy and lot of
users
>on the system and the package might be used but why no errors
>Please shed some light
>Thanks in advance
>regards
Received on Wed Oct 20 1999 - 08:25:45 CDT