Environment - Oracle 8.1.7, utplsql V2.08 I am setting up scripts to initialize our development environment. I wrote the utldsuite packge to assist in this...
Dan Spencer
spencer@...
Dec 3, 2001 5:13 pm
43
Hi all, I am attaching the assertion method for the REFCURSOR. I send the code earlier to Steve and he thought I should mail to the list so that everybody can...
Venky Mangapillai
venky11@...
Dec 3, 2001 8:24 pm
44
I am testing a stand-alone procedure called "DELETEALLAUDIT". Even when I use utGen to generate the test package, I get a "Warning...no tests were identified...
For obvious reasons, utPLSQL contains no generic way to compare records for equality. The attached procedure will create a COMPARE_RECORD package containing...
Is there a way to handle a RAISE_APPLICATION_ERROR call if the procedure you are testing is expected to call it? How would you keep the test from blowing up? ...
I ran into the same thing. If you encapsulate that test in a nested being-exception-end block, you can do it. For example, I have a test to make sure that...
... Uh, did you check out utAssert.throws? I wrote it to handle just this situation and it has been in utPLSQL for a while. It takes a block of code as a...
Dear uTPLSQLers: Imagine my surprise when I received an ad over the utPLSQL list from etoyshop7@.... I don't know how that email was added to our list; I...
Hi friends if you are interested in passing any IT certification like MCSE, MCSD, MCDBA, CCNA, CCNP, CCDA, CCIE, OCP ( Both DBA & Developer ), JAVA and ALL...
Now that we have received our second ad from a phony member of the utPLSQL listserve, I have switched it to a moderated list. The only moderation that will...
Hi, I have been trying to use the utAssert.throws method within our test unit. I have followed the example in the documentation and have been unable to get it...
... Well, it won't work if it's a function, as the call gets executed as a piece of dynamic PL/SQL. It also looks like e_negative_value needs qualifying with...
Suppose I have a trigger named 'myTrigger'.
How does this play into the naming conventions?
Currently, I have my tests in a package called ut_myTrigger, but...
Chris, Not a bad fix, but it rather assumes the return type matches the global variable. What do you do when it doesn't? Declare more variables of given type?...
Padfield, James
jpadfiel@...
Jan 17, 2002 3:12 pm
59
While making utAssert.throws more sophistocated to either accept a return type as an argument would be great, I don't see it as a burden to add global...
I have found away to run unit tests in TOAD 7.2 from the toolbar or via a shortcut. To set this up: 1) Put the attached file somewhere like C:\utplsql 2) On...
Does utPLSQL analyze the code coverage ? Are there any freebies available for that ? It should mention how many lines of PL/SQL code is actualy tested by the...
... That is a wonderful idea, but it does not do so right now. How can we do this? Integrate with DBMS_PROFILER which DOES provide code coverage analysis. ... ...
... utplsql? Venky posted some code to do ref cursors : http://groups.yahoo.com/group/utPLSQL-Info/message/43 I haven't looked at it myself. He also has been...
Hello, I am relatively new to utplsql. I would like to be able to test my triggers. Does anyone have any suggestions as to how I could use utplsql for this? ...
Damon Torgerson
damon@...
Feb 6, 2002 4:36 pm
68
... You can only test procedures that are called from within your triggers, but there is currently no way to directly test a trigger within the test harness. I...
... Actually, while I don't have the code available -- I no longer work at the company -- I tested a series of triggers with the test harness. What I did was I...
Currently I am developing an application that can be used to managed non-fatal errors and data processing information. The app allows a user to define message...
For those of you using my script, or thinking about it, there is a minor change to the instructions. As pointed out to me by Jeff Smith at Quest, the script...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
