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...
Hi folks, I've got a problem with how to call utassert.eqqueryvalu on a Version - 7.3.4.0.0 db. the same test runs well on a version 8 something: drop table...
Juergen Aschenbrenner
jasche@...
Aug 13, 2002 5:51 pm
130
Hi albert, I don't think it has something to do with execution rights granted, as You see that the *utassert.this* in the exception part works properly. I...
Juergen Aschenbrenner
jasche@...
Aug 14, 2002 12:44 pm
131
... as You see that the *utassert.this* in the exception part works properly. I guess, but I am not sure that there is a bug in the *utassert.eqqueryvalu*...
Hi Albert and Chris, I checked this and it worked :o). Thanks for Your help. Cheers Juergen ... as You see that the *utassert.this* in the exception part works...
Juergen Aschenbrenner
jasche@...
Aug 16, 2002 10:49 am
133
Hi All, My requirement is, I need to generate Excel reports from Oracle with Data. Now am using Java as Middle tier to generate Excel Report. Instead of Java,...
<<Hi All, My requirement is, I need to generate Excel reports from Oracle with Data. Now am using Java as Middle tier to generate Excel Report. Instead of...
This question is not appropriate for this list (we are interested here in the utPLSQL unit testing framework). Anyway... Why don't you produce a CSV file? This...
Does anyone have any examples of ways they used to test the effects of triggers or any procedures that perform DML on database tables? ...
mark_blakey@...
Sep 4, 2002 2:00 pm
138
If you can describe what you're trying accomplish, I probably can help. The best approach I've found is to simply create an anonymous PL/SQL block in a text...
RR
rgosling@...
Sep 4, 2002 2:20 pm
139
One, admittedly kludgy, way I have used to check the effects of operations that can't be run from utplsql, but still define and execute checks from utplsql, is...
Friends, At the end of September, I am going to change the utPLSQL-Info discussion group into an announcement. I will do this not because I don't like ...
... I don't want to sound ungrateful for Patrick's work, but I am not sure why we are moving to _yet another_ discussion forum for utPLSQL. So far, we have...
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.
