I work for Oracle and we run all the Unit tests in the cron job. I was wondering if we can run the entire suite and get a HTML report out. ( with nice colors, ...
... Well, all results are actually stored in the utr_outcome table. I believe therefore that it would be rather straightforward for *someone* (ie, not me!) to...
While it doesn't quite fit your request, I run the following script after each test run. The spooled output is linked to a web page. It is a pretty basic...
This is easy to do using the PL/SQL Web Toolkit and the HTTP Server that comes with Oracle 8.1.7. I built a rudimentary proof of concept version called ...
When I run utplsql_update.sql for 2.0.9 ( upgrading from a 2.0.8 installation) it gives me a bunch of errors. What am I doing wrong? Errors for PACKAGE...
... You aren't doing anything wrong. I did something wrong: I have not updated the upgrade script. In fact, what you should do is run utplsql_install and it...
Have a look on ORASNAP freeware for Oracle (very easy to find on google). It may helps to understand how to do your work. ... Gery Pannequin - Independant...
Gery PANNEQUIN
gpannequin@...
Mar 4, 2002 2:31 pm
90
I'm From Albania and i just wanted to say that I don't know quite a lot in PL/SQL but I think jus that I'm in the right group. ===== << Laert...
LaertOsmëni
laerto@...
Mar 7, 2002 5:49 pm
91
RE Version 2091 Population of ut_assertion fails with primary key constraints failure. Primary key value 15 repeated in insertion steps. I changed...
Larry Winkler
lawrence.winkler@...
Mar 9, 2002 2:51 pm
92
Dear all, I have once again revamped the documentation for utPLSQL. The new version is available online at: http://utplsql.sourceforge.net/Doc/index.html The...
Hi all, I'm new to the utPLSQL world so if you can help me that is great. I have installed utPLSQL and running the examples to see how it works. Most of the...
lai@...
Mar 13, 2002 3:37 pm
94
... I have added a document to SourceForge describing how to add documentation. It is to be found at ...
[I have finally managed to get access to this group from my workplace...] I need to test some existing stored procs with names that are at the 30-char limit....
... Frankly, I am a bit embarrassed that utPLSQL doesn't already deal with this situation. I am looking at a fix so that when you call utPLSQL.test you can ...
Hi, I have posted the bug on utplsql.sf.net, repeating here just in case nobody traces bug reports there :) When installing utPLSQL ver.2.0.9.1 on Oracle 8,...
Hi all, I'm having trouble installing utPLSQL on my Oracle DB. The version is Oracle8i Enterprise Edition Release 8.1.7.1.0. I simply ran the utplsql_install...
... This does sound suspiciously like the DB is broken. Do you have access to the profiler (DBMS_PROFILER package)? You could try running with this and then...
Friends, Patrick Barel in the Netherlands has generously made available to us his own custom-built discussion forum software to allow us to build threaded ...
Hello All, I had posted this on the sourceforge.net bug tracker. I'm posting it here again, just in case. if you want to look at the attachements, refer to the...
I've just upgraded to TOAD 7.3. Quest now include the script I wrote to run utPLSQL from TOAD, plus links to the project homepage at SourceForge. Hey, I even...
Hi folks, I just fooled a bit around with the utplsql packackage. I got the betwnstr example run and right after that I tried to integrate my testing scripts...
Juergen Aschenbrenner
jasche@...
May 16, 2002 2:00 pm
105
... Try putting UT_BAR in the FOO schema and run utplsql.test logged in as FOO. If I remember correctly, by default utPLSQL assumes that the program or package...
Hi, Does anybody have any idea how to write unit test for testing high- level functions ? I say that function is high-level if it calls some other nontrivial ...
Thanx Spencer, David and Steven for Your quick reply, ok, now I put UT_BAR along with BAR into the FOO-schema and granted execute rights un UT_BAR to UTPLSQL....
Juergen Aschenbrenner
jasche@...
May 21, 2002 3:58 pm
108
ok, finally I got it run. Another problem I encountered was that I gave the schema where I put the utplsql package in the same name, e.g. 'utplsql'. When I try...
Juergen Aschenbrenner
jasche@...
May 23, 2002 2:16 pm
109
... to ... Hmmm, I wish I had a clever solution to this, as I have encountered a related problem. I have a routine which sends out a notification email to...
... us his ... threaded ... I am afraid this forum tends not to work. It's more like ORA-03113 errors generator :) I was never be able to use any part of it...
Thinking about this problem posed by Albert, I wondered to myself if it
was possible to recompile a package into a 'testing' form before the tests
are run and...