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...
I'm not an expert on Java, especially when it comes to using it in stored procs in Oracle. I am interested to know if anyone uses JUnit to test this code. Is...
If I understood correctly, Chris proposed to write code like that: PROCEDURE My_Proc IS .... /**P ONLY*/ ret_code := My_Function(in_number); /*P ONLY**/ /**T...
By the way, the Oracle PL/SQL Pipetalk forum (http://pipetalk.revealnet.com/~plsql) performs much-much better since June 1, 2002. I think that utPLSQL forum...
Hi folks, I would like to inquire about what the better way is to match a given collection against table data: To store the collection in a temporarely created...
Juergen Aschenbrenner
jasche@...
Jun 3, 2002 12:54 pm
116
Hello all, Joined yesterday. First post, since my previous first post hasn't appeared! I'm having a look at utPLSQL, but haven't used it in anger yet. (a)...
Great Post! Just what I wanted to say. In a former code generation project, I had implemented a feature like this (Rimmer Method) for test mode, I also had...
Glad to see discussion on this very important topic. The idea of synonyms is interesting, but functions tend to call mostly functions of own schema. I can...
Albert, ... The thing to remember is that for non-dynamic code the synonym lookup is only used at _compile_ time, which is why you must recompile the procedure...
I wrote the following snipped to illustrate my problem. It must have something to do with a NTHVAL component. Maybe someone can give me a hint what it is....
Juergen Aschenbrenner
jasche@...
Jun 5, 2002 5:39 pm
121
I am thinking of giving a presentation at this year's UKOUG in December on utPLSQL to raise the profile of the project (and maybe raise my own profile too...
Problem: in ut_setup method, I'd like to insert some test data. But some of the tables are under another schema. To enable the inserts, I should give grants to...
Create a package to create the data for the other schema, and place it in the other schema. Call it from your ut_setup. It should execute with owner privilege,...
Hi everybody, we're considering the use of utPLSQL to include unit testing in the ETL system we're developing with Oracle Warehouse Builder. Has anybody tried...
Hi Folks, I tried to install the utplsql on a 7.3.4.0.0 oracle data base. The installation script had proplems with the *utreceq* package as it couldn't handle...
Juergen Aschenbrenner
jasche@...
Aug 6, 2002 4:12 pm
128
I have just uploaded the new version to SourceForge. (http://sourceforge.net/project/showfiles.php?group_id=6633) The changes are: utRecEq package spec fixed...
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.
