18 June 2010

A Focus on Unit Testing and new supporting material

SQL Developer's Unit Testing feature is doing well. Those who are using this new functionality in SQL Developer 2.1 are finding it very useful and are already asking for more functionality. (Isn't that the way, once you get to grips with a product you can start saying "wouldn't it be good if we could also...") so the SQL Developer Exchange is starting to build up a few requests.

Unit Test Online Demonstrations
For those of you not yet familiar with PL/SQL Unit Testing or have not yet quite got to grips with this feature, we have published a number of new short online demonstrations. You can find these from the Online Demonstrations link on our main page on OTN. All the unit test demonstrations are grouped together, so you can pick the one's you're interested in or watch them all.

Unit Test Webcast
If watching the online demos is not your thing, you can watch the 30 min webcast. The latest webcast was on Unit Testing, which has now been recorded and is available on OTN for you to watch and listen to. All our webcasts are on OTN on the Webcast Series.

9 comments:

Phil R Lawrence said...

The links seem to be broken, both for the new Unit Testing Viewlets at the "Tutorials - Demonstration Viewlets" page and the two most recent Previous Recordings at the "Oracle SQL Developer and SQL Developer Data Modeler Webcast Series" page.

Sue said...

Phil,

This is an ongoing frustration of ours. Either try again immediately and you'll find they're not broken, or try again later. There was an issue with downloading a while back and we're told it's fixed. The links are correct and the downloads are there, it seems there is something not quite registering.

Sorry about that!
Sue

Anonymous said...

Please add a unit test to do a query returning 900,000 rows and then save it as csv/tab delimited. SQLDeveloper will consume all memory on my 4gb machine and then will crash. Can't the save as a file format just spool the rows to disk and then reprocess them into an CSV file instead of trying to load all of them into memory?
We get this request on a weekly basis to do one off 900,000+ row custom data extracts for our users and provide them a CSV file format.

Anonymous said...

Hi Sue,
I'm using the new unit test feature in SQL Developer, but I found one critical bug. Our company has metalink access, but we cannot report bugs related to SQL Developer.
Can you help me?
http://forums.oracle.com/forums/thread.jspa?threadID=1117070&tstart=0 (ututil utility is not correctly working)
And if I scroll down in the test screen to show Test implementation, it takes 100% CPU. Tested on 3 different computers :(
I was very happy, when I found, that SQLDev includes unit test framework, but these bugs drives me up the wall...
Thanks for any answer
Mark

Sue said...

If you don't have a Metalink account, then the place to post queries is the forum, as you have done. The team monitor this and should respond there.

Sue

RAJESH said...

Hi Sue:

I am just looking at the ppt (Whats New in Oracle Application Development) from AskTom.oracle.com

http://asktom.oracle.com/pls/apex/z?p_url=ASKTOM%2Edownload_file%3Fp_file%3D3400036420700662395&p_cat=oow_2010.zip&p_company=822925097021874

There it's mentioned about some features of SQL Developer 3.0. But checked in otn.oracle.com its not available. Can you provide details about when SQL Developer 3.0 will be available for use?

Sue said...

It is an Oracle policy not to disclose any release dates. Watch the OTN and SQL Developer pages for news and updates.

Sue

Anonymous said...

Hi Sue,

I just downloaded the SQL Developer 3.0 EA release and am trying to test the Unit Testing feature by calling a function that returns a ref cursor but keep getting an Invalid Column Index. Is there any example or a demo for this scenario? Your help is greatly appreciated.

Sue said...

You should use the forum for all your early adopter queries. This allows others to benefit from the query and response. Also the developers are monitoring the forum.

Sue