I have made some changes to the SourceForge site: 1) I have disabled some of the features which are not being used, such as the mailing lists, forums and CVS....
Oh, yes - I forgot to say, for those that haven't seen it, the utPLSQL site is at http://sourceforge.net/projects/utplsql. It was set up a long while back, but...
Guys, I believe that its reasonable to say the utPLSQL is at least partly based on the jUnit framework. Is there anything out there for logging in PL/SQL that...
... Can you give some more detail about what jLog does? I'm unfamiliar with jLog (Steven may know more..) and searching for it on Google seems to pull back...
... Have you seen PLVlog and PLVtrc, which are packages that are part of PL/Vision Lite, written by Steven? This was distributed with his book 'Advanced...
Hi there, unfortunately I do not know jLog or log4J ! But as far as I read the overview of these, I think you should check my PlsTrc application. It's...
Hi - I'm new to utPL/SQL and am having what I am sure is a simple problem. I have created a new package called ut_users_pack, which will test verious...
... To test tax_server.users_pack.getusers, the package specification should be: CREATE OR REPLACE PACKAGE ut_users_pack IS PROCEDURE ut_setup; PROCEDURE...
Hi, I'm currently trying to convert a programming team I'm working with over to XP and utPLSQL. However, one point of resistance is they very much like the...
... I don't know of a way to do this, but then I do not know Loader well these days. Can I kick off a stored procedure during my load process? If so, then ...
Hello, We are creating stored procedures containing htp.p commands to build html to generate web pages using Oracle Application Server (OAS) Obviously these...
Pete You could build a test harness based around grabbing the info out of the HTP buffer. If you're not sure how to do that, look at the source for ...
Doug Gault
doug.gault@...
Nov 19, 2001 3:44 pm
32
... On a similar note, I've often thought that it would be difficult to test procedures that output to DBMS_OUTPUT, because of the way that utPLSQL is...
... Isn't the real issue that we would have to ask developers to use a utPLSQL wrapper for DBMS_OUTPUT.PUT_LINE in their own application code? That's the ...
Michael Corum logged this request at the SourceForge site, thought you might want to see it: In the normal xUnit frameworks (JUnit as an example), the setup...
Friends, You will find at http://groups.yahoo.com/group/utPLSQL-Info/files release 2.0.8.1 of utPLSQL. This release: * Fixes a number of install errors (which...
I have two tables I am using Utassert.Eqtable to evaluate and in the table (& its copy) there is a CLOB object. Does utPLSQL support this datatype? I get an...
... Sigh...yes, the current implementation of eqTable, relying MINUS, will not work with LOBs. Just to encourage us all to use the "new system" (which we are...
I have now added the initial list of tasks to the Task Manager on the SourceForge site. At the moment, we are concentrating on the addition of new assertions...
While entering the tasks into the SourceForge site, the one which suggests "neq" assertions to mirror the "eq" ones got me thinking. If we are going down that...
I have added a patch to SourceForge for users of Oracle 7.3. This fixes a table definition which was using an Oracle 8 datatype - CLOB. I have also uploaded an...
I have updated the guidelines for assertion developers. There is a more detailed description of the steps required to fit in with the rest of the framework....
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...
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.
