As said before, this has been built already.
Enhancements can be posted anywhere in the forum.
Soon as we have one, I will create a category for this and move the message
there.

At 02:39 PM 9/25/2002 -0400, you wrote:


>   Many web forums have options to subscribe to new messages
>      to Deliver to Users E-mail
>
>   Some have the option to subscribe only to threads that you have opened or
>replied to,
>       This is especially helpful for busy forums.
>
>   Perhaps, the person who set this up might be able to add this type of
>feature?
>
>   Where do you post enhancement requests for the bbs?
>
>
>
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>utPLSQL-Info-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


groet,
Patrick

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Patrick Barel       (pbarel@...)

VDA informatiebeheersing bv
Seinstraat 32
1223 DA Hilversum

Postbus 2294
1200 CG Hilversum

Telefoon +31 (0)35 655 44 33
Fax +31 (0)35 655 44 22

http://www.vda.nl
http://www.oracledeveloper.nl
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

DISCLAIMER:
De informatie, opgenomen in dit bericht, kan vertrouwelijk zijn en is
uitsluitend bestemd voor de geadresseerde(n). Indien u dit bericht
onterecht ontvangt wordt u verzocht de inhoud niet te gebruiken en de
afzender te informeren door het bericht te retourneren en uit uw bestanden
te verwijderen. De werkgever van afzender (VDA informatiebeheersing BV)
aanvaardt geen enkele aansprakelijkheid voor enigerlei schade,
voortvloeiend uit het gebruik en/of acceptatie van de inhoud van het
bericht. Tevens is de werkgever van de afzender niet aansprakelijk voor de
inhoud en eventuele schadelijke gevolgen van door haar medewerkers
verzonden persoonlijke e-mailberichten. De rechten (copyright) op de inhoud
van dit e-mail bericht of de bijbehorende attachments behoren aan VDA toe.

The forum can also send out emails.
Complete messages, or just notifications that a new message was added.
You can subscribe to a category (using your profile) or a single thread.
The forum can also send you your password (in case you forget).
I will probably build a username and password retrieval tool to retrieve
your username and password by sending in your email-address. (that is a
nice feature by the way).

At 12:59 PM 9/25/2002 -0500, you wrote:
>I too had problems when setting up my account. I would like to mention
>publicly that Patrick was very responsive to my problem in getting my
>account activated. He resolved my issue very quickly. I think that the forum
>is well designed for what it is and should work well for discussions for
>those choosing to use it.
>
>That said, I do have a problem with the new forum. I just prefer an
>email-based discussion group over a web-based forum simply because with an
>email-based group, the messages come to me. Someone sends a message and it
>appears in my Inbox. With a web based discussion forum, I have to choose to
>log on and then read the messages. While that certainly isn't a difficult
>thing, I am quite busy and I won't manage to remember to log on, or I won't
>have time to log on, to read the forum very often. As it is now I can
>quickly click on that message arriving via email and read it and be back to
>work in less time than I could have even logged on to see if there are any
>new messages waiting on the web forum. With a low-volume list, such as this
>list has been most of the time, one could waste time logging in only to find
>that there are no new messages to read. With email this issue never arises.
>
>Steven has made his decision and the group is his to control. For better or
>worse, worse in my case, he's decided to move to a web-based forum for
>utPLSQL discussions. I will log in from time to time as work/time permits to
>see what discussions are ongoing, but likely it'll only be once or twice a
>month.
>
>John
>
>-----Original Message-----
>From: Patrick Barel [mailto:pbarel@...]
>Sent: Wednesday, September 25, 2002 12:38 PM
>To: utPLSQL-Info@yahoogroups.com
>Subject: RE: [utPLSQL-Info] Re: Upcoming changes to utPLSQL-Info list
>
>
>Dear utPL/SQL users,
>
>I would like to point out the reason I have offered Steven the use of my
>forum software.
>
>- First of all, I don't like the mailing list, because I get confused who
>responded to who on what problem.
>- I wanted to help Steven out, because revealnet shut down it's
>messageboard.
>- I really like a forum which has threads and branches, so more than one
>person can reply to a message (unlike the pipelines, where you can only
>reply to the last message) (Which doesn't mean the pipelines is a bad
>board, by the way. It's one of the best in the world).
>- It's a great test for my forum to have some really experienced users on
>the forum. Hopefully you have some ideas to make it better.
>- We have (almost) full control on the features we want to use on the
>forum. If it's not there, then it can probably be build by me.
>
>Currently, we have just migrated the oracle server on which the database
>runs to an Oracle 9i Release 2 database. We are experiencing some minor
>problems when logging in. It gives some ODBC error concerning a default
>login not allowed etc.
>Problem is just that I am away from the office a lot and that I am not
>getting this error when using the forum when I am in the office.
>We will fix this problem as soon as possible. Until that time, anyone who
>registers, please send me an email with your name and loginname so I can
>activate your account (I've created admin pages for this).
>
>Even if you all decide not to use 'my' forum, then please let me know of
>any bugs/enhancements.
>That's all.
>
>
>To unsubscribe from this group, send an email to:
>utPLSQL-Info-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


groet,
Patrick

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Patrick Barel       (pbarel@...)

VDA informatiebeheersing bv
Seinstraat 32
1223 DA Hilversum

Postbus 2294
1200 CG Hilversum

Telefoon +31 (0)35 655 44 33
Fax +31 (0)35 655 44 22

http://www.vda.nl
http://www.oracledeveloper.nl
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

DISCLAIMER:
De informatie, opgenomen in dit bericht, kan vertrouwelijk zijn en is
uitsluitend bestemd voor de geadresseerde(n). Indien u dit bericht
onterecht ontvangt wordt u verzocht de inhoud niet te gebruiken en de
afzender te informeren door het bericht te retourneren en uit uw bestanden
te verwijderen. De werkgever van afzender (VDA informatiebeheersing BV)
aanvaardt geen enkele aansprakelijkheid voor enigerlei schade,
voortvloeiend uit het gebruik en/of acceptatie van de inhoud van het
bericht. Tevens is de werkgever van de afzender niet aansprakelijk voor de
inhoud en eventuele schadelijke gevolgen van door haar medewerkers
verzonden persoonlijke e-mailberichten. De rechten (copyright) op de inhoud
van dit e-mail bericht of de bijbehorende attachments behoren aan VDA toe.

Many web forums have options to subscribe to new messages
      to Deliver to Users E-mail

   Some have the option to subscribe only to threads that you have opened or
replied to,
       This is especially helpful for busy forums.

   Perhaps, the person who set this up might be able to add this type of
feature?

   Where do you post enhancement requests for the bbs?

I too had problems when setting up my account. I would like to mention
publicly that Patrick was very responsive to my problem in getting my
account activated. He resolved my issue very quickly. I think that the forum
is well designed for what it is and should work well for discussions for
those choosing to use it.

That said, I do have a problem with the new forum. I just prefer an
email-based discussion group over a web-based forum simply because with an
email-based group, the messages come to me. Someone sends a message and it
appears in my Inbox. With a web based discussion forum, I have to choose to
log on and then read the messages. While that certainly isn't a difficult
thing, I am quite busy and I won't manage to remember to log on, or I won't
have time to log on, to read the forum very often. As it is now I can
quickly click on that message arriving via email and read it and be back to
work in less time than I could have even logged on to see if there are any
new messages waiting on the web forum. With a low-volume list, such as this
list has been most of the time, one could waste time logging in only to find
that there are no new messages to read. With email this issue never arises.

Steven has made his decision and the group is his to control. For better or
worse, worse in my case, he's decided to move to a web-based forum for
utPLSQL discussions. I will log in from time to time as work/time permits to
see what discussions are ongoing, but likely it'll only be once or twice a
month.

John

-----Original Message-----
From: Patrick Barel [mailto:pbarel@...]
Sent: Wednesday, September 25, 2002 12:38 PM
To: utPLSQL-Info@yahoogroups.com
Subject: RE: [utPLSQL-Info] Re: Upcoming changes to utPLSQL-Info list


Dear utPL/SQL users,

I would like to point out the reason I have offered Steven the use of my
forum software.

- First of all, I don't like the mailing list, because I get confused who
responded to who on what problem.
- I wanted to help Steven out, because revealnet shut down it's
messageboard.
- I really like a forum which has threads and branches, so more than one
person can reply to a message (unlike the pipelines, where you can only
reply to the last message) (Which doesn't mean the pipelines is a bad
board, by the way. It's one of the best in the world).
- It's a great test for my forum to have some really experienced users on
the forum. Hopefully you have some ideas to make it better.
- We have (almost) full control on the features we want to use on the
forum. If it's not there, then it can probably be build by me.

Currently, we have just migrated the oracle server on which the database
runs to an Oracle 9i Release 2 database. We are experiencing some minor
problems when logging in. It gives some ODBC error concerning a default
login not allowed etc.
Problem is just that I am away from the office a lot and that I am not
getting this error when using the forum when I am in the office.
We will fix this problem as soon as possible. Until that time, anyone who
registers, please send me an email with your name and loginname so I can
activate your account (I've created admin pages for this).

Even if you all decide not to use 'my' forum, then please let me know of
any bugs/enhancements.
That's all.

Dear utPL/SQL users,

I would like to point out the reason I have offered Steven the use of my
forum software.

- First of all, I don't like the mailing list, because I get confused who
responded to who on what problem.
- I wanted to help Steven out, because revealnet shut down it's messageboard.
- I really like a forum which has threads and branches, so more than one
person can reply to a message (unlike the pipelines, where you can only
reply to the last message) (Which doesn't mean the pipelines is a bad
board, by the way. It's one of the best in the world).
- It's a great test for my forum to have some really experienced users on
the forum. Hopefully you have some ideas to make it better.
- We have (almost) full control on the features we want to use on the
forum. If it's not there, then it can probably be build by me.

Currently, we have just migrated the oracle server on which the database
runs to an Oracle 9i Release 2 database. We are experiencing some minor
problems when logging in. It gives some ODBC error concerning a default
login not allowed etc.
Problem is just that I am away from the office a lot and that I am not
getting this error when using the forum when I am in the office.
We will fix this problem as soon as possible. Until that time, anyone who
registers, please send me an email with your name and loginname so I can
activate your account (I've created admin pages for this).

Even if you all decide not to use 'my' forum, then please let me know of
any bugs/enhancements.
That's all.

At 05:36 PM 9/25/2002 +0300, you wrote:
>Let's vote ! :)
>
>It is possible to create a poll on http://groups.yahoo.com/group/utPLSQL-Info/
>
>The forums to choose from (please add your links):
>
>http://utplsql.oracledeveloper.nl
>
>http://groups.yahoo.com/group/utPLSQL-Info/
>
>https://sourceforge.net/forum/forum.php?forum_id=20546
>
>http://pipetalk.revealnet.com/~plsql
>
>
>Albert.
>
>-----Original Message-----
>From: Chris Rimmer [mailto:chris@...]
>Sent: Wednesday, September 25, 2002 14:19
>To: utPLSQL-Info@yahoogroups.com
>Subject: [utPLSQL-Info] Re: Upcoming changes to utPLSQL-Info list
>
>
>--- In utPLSQL-Info@y..., Steven Feuerstein <steven@s...> wrote:
> > Thanks to the efforts of Patrick Barel, we can use real discussion
> > forum software that allows us to have much more interesting and
> > in-depth threads of conversations.
>
>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 had an O'Reilly WebBoard and 2 different Yahoo groups, not to mention
>the forums on the SourceForge site.  I have to admit also that I have had
>some problems using the new forum.
>
>Wouldn't it have made more sense to standardise on the SourceForge forums,
>so that everything is in one place?
>
>Chris
>
>
>To unsubscribe from this group, send an email to:
>utPLSQL-Info-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


groet,
Patrick

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Patrick Barel       (pbarel@...)

VDA informatiebeheersing bv
Seinstraat 32
1223 DA Hilversum

Postbus 2294
1200 CG Hilversum

Telefoon +31 (0)35 655 44 33
Fax +31 (0)35 655 44 22

http://www.vda.nl
http://www.oracledeveloper.nl
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

DISCLAIMER:
De informatie, opgenomen in dit bericht, kan vertrouwelijk zijn en is
uitsluitend bestemd voor de geadresseerde(n). Indien u dit bericht
onterecht ontvangt wordt u verzocht de inhoud niet te gebruiken en de
afzender te informeren door het bericht te retourneren en uit uw bestanden
te verwijderen. De werkgever van afzender (VDA informatiebeheersing BV)
aanvaardt geen enkele aansprakelijkheid voor enigerlei schade,
voortvloeiend uit het gebruik en/of acceptatie van de inhoud van het
bericht. Tevens is de werkgever van de afzender niet aansprakelijk voor de
inhoud en eventuele schadelijke gevolgen van door haar medewerkers
verzonden persoonlijke e-mailberichten. De rechten (copyright) op de inhoud
van dit e-mail bericht of de bijbehorende attachments behoren aan VDA toe.

Let's vote ! :)

It is possible to create a poll on http://groups.yahoo.com/group/utPLSQL-Info/

The forums to choose from (please add your links):

http://utplsql.oracledeveloper.nl

http://groups.yahoo.com/group/utPLSQL-Info/

https://sourceforge.net/forum/forum.php?forum_id=20546

http://pipetalk.revealnet.com/~plsql


Albert.

-----Original Message-----
From: Chris Rimmer [mailto:chris@...]
Sent: Wednesday, September 25, 2002 14:19
To: utPLSQL-Info@yahoogroups.com
Subject: [utPLSQL-Info] Re: Upcoming changes to utPLSQL-Info list


--- In utPLSQL-Info@y..., Steven Feuerstein <steven@s...> wrote:
> Thanks to the efforts of Patrick Barel, we can use real discussion
> forum software that allows us to have much more interesting and
> in-depth threads of conversations.

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 had
an O'Reilly WebBoard and 2 different Yahoo groups, not to mention the forums on
the SourceForge site.  I have to admit also that I have had some problems using
the new forum.

Wouldn't it have made more sense to standardise on the SourceForge forums, so
that everything is in one place?

Chris

--- In utPLSQL-Info@y..., Steven Feuerstein <steven@s...> wrote:
> Thanks to the efforts of Patrick Barel, we can use real discussion
> forum software that allows us to have much more interesting and
> in-depth threads of conversations.

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 had
an O'Reilly WebBoard and 2 different Yahoo groups, not to mention the forums on
the SourceForge site.  I have to admit also that I have had some problems using
the new forum.

Wouldn't it have made more sense to standardise on the SourceForge forums, so
that everything is in one place?

Chris

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 to use  dbms_application_info.read_client_info
to select the test to run.  I define test package (unprefixed) that is
defined with SAMEPACKAGE=TRUE.  The package contains a setup like:

  PROCEDURE ut_setup
   IS
   BEGIN
       dbms_application_info.read_client_info(sMODE);
   END;


The package body is a series of :

IF sMODE=  ?  THEN

SQL statement or something to get the result we are looking for

utAssert.?  to check and report the result

ELSE IF smode=?  then

....
END IF;

Then we call the test package immediately after call to
dbms_application_info.wriite_client_info  that tells the test package
what to write.  You can even pass results into sMODE if you want to
parse them out of a string like

TEST_1:VALUE

and then check the value.

mark_blakey@... wrote:

>Does anyone have any examples of ways they used to test the effects of triggers
>or any procedures that perform DML on database tables?
>

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 file and run something like this against your code:

SET SERVEROUTPUT ON SIZE 1000000
SPOOL my_output.lst

DECLARE
     --set up variables to be used
     var1 NUMBER := 0;
     var2 VARCHAR2(30);

BEGIN
     -- initialize whatever else in the environment

     --call whatever makes your trigger trip ;-)

     --select the expected changes to a cursor
     DBMS_OUTPUT.PUT_LINE(var1 || var2);

END;
/

ROLLBACK;

SPOOL OFF

You can also get information on user-defined triggers via pl/sql plus by
selecting the trigger definition from USER_TRIGGERS.
-rg

----- Original Message -----
From: <mark_blakey@...>
To: <utPLSQL-Info@yahoogroups.com>
Sent: Wednesday, September 04, 2002 8:57 AM
Subject: [utPLSQL-Info] Trigger tests


> Does anyone have any examples of ways they used to test the effects of
triggers
> or any procedures that perform DML on database tables?
>
>
>
****************************************************************************
**************************************************************************
> This e-mail has been prepared using information  believed  by  the  author
to be
> reliable and accurate, but Thales Information Systems Finance makes  no
> warranty  as to accuracy or completeness. In particular Thales Information
> Systems Finance does not  accept  responsibility  for  changes  made to
this
> e-mail after it was sent.  Any  opinions expressed in this document are
those of
> the author and do  not  necessarily reflect the opinions of the company or
its
> affiliates. They may be subject to change without notice.
> This  e-mail,  its  content  and any files transmitted with it are
intended
> solely   for   the  addressee(s)  and  may  be legally  privileged  and/or
> confidential. Access by any other party is unauthorised without the
express
> written permission of the sender. If you have received this e-mail in
error you
> may  not  copy  or use the contents, attachments or information in any
way.
> Please  destroy  it and contact the sender via the Thales Information
Systems
> Finance switchboard in London at +44  (0) 20 7650 0100 or via e-mail
return.
> This message and any attachments have been scanned
> for viruses prior to leaving the originators network. The originator does
not
> guarantee the security of this message and will not be responsible for any
> damages arising from any alteration of this message by a third party or as
a
> result of any virus being passed on.
>
****************************************************************************
***************************************************************************
>
>
>
>
> To unsubscribe from this group, send an email to:
> utPLSQL-Info-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

Does anyone have any examples of ways they used to test the effects of triggers
or any procedures that perform DML on database tables?


********************************************************************************\
**********************************************************************
This e-mail has been prepared using information  believed  by  the  author to be
reliable and accurate, but Thales Information Systems Finance makes  no
warranty  as to accuracy or completeness. In particular Thales Information
Systems Finance does not  accept  responsibility  for  changes  made to this
e-mail after it was sent.  Any  opinions expressed in this document are those of
the author and do  not  necessarily reflect the opinions of the company or its
affiliates. They may be subject to change without notice.
This  e-mail,  its  content  and any files transmitted with it are intended
solely   for   the  addressee(s)  and  may  be legally  privileged  and/or
confidential. Access by any other party is unauthorised without the express
written permission of the sender. If you have received this e-mail in error you
may  not  copy  or use the contents, attachments or information in any way.
Please  destroy  it and contact the sender via the Thales Information Systems
Finance switchboard in London at +44  (0) 20 7650 0100 or via e-mail return.
This message and any attachments have been scanned
for viruses prior to leaving the originators network. The originator does not
guarantee the security of this message and will not be responsible for any
damages arising from any alteration of this message by a third party or as a
result of any virus being passed on.
********************************************************************************\
***********************************************************************

Friends,

If you are on Oracle9i, please make sure that you upgrade to utPLSQL
2.0.9.2, which is available at:

https://sourceforge.net/project/showfiles.php?group_id=6633

Otherwise, the utPLSQL install may not recognize that you are on a
post-Oracle8 version and will install what is in essence an "old" version
of the software (not utilizing any Oracle8i+ features).

Many thanks for your interest in utPLSQL,
Steven Feuerstein

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 would be easy with either of the
UTL_FILE or DBMS_OUTPUT packages.


-----Original Message-----
From: Chandra S.Reddy [mailto:chandrareddym@...]
Sent: 23 August 2002 14:55
To: utPLSQL-Info@yahoogroups.com
Subject: [utPLSQL-Info] Excel reports from PL/SQL


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, it could be better If I generate Excel report from the
PL/SQL code.
With Java as interface, am facing so many problems. Performance came down
drastically.
Can any one give me solution in this reg.

Thanks 'n' Regards.
Chandra.



*****************************************************************
The information in this email and in any attachments is
confidential and intended solely for the attention and use
of the named addressee(s). This information may be
subject to legal professional or other privilege or may
otherwise be protected by work product immunity or other
legal rules.  It must not be disclosed to any person without
our authority.

If you are not the intended recipient, or a person
responsible for delivering it to the intended recipient, you
are not authorised to and must not disclose, copy,
distribute, or retain this message or any part of it.
*****************************************************************

<<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, it could be better If I generate Excel report from the
PL/SQL code.
With Java as interface, am facing so many problems. Performance came down
drastically.
Can any one give me solution in this reg.

Thanks 'n' Regards.
Chandra.>>

Hi Chandra,

I would suggest you use PL/SQL to make a textfile (comma separated or with @
for instance) that you import in a new excel sheet, save this under the name
rawdata.xls.
In a second sheet you have the formatted report that has no data but only
references to the cells in rawdata.xls

It is possible to use an excel macro to automate the import and opening and
printing of the report sheet.

Hope to have helped you,
Henk Vedder



Met vriendelijke groet,
Henk Vedder
HR371
tel. 9551

================================================================================
PGGM heeft aan het opstellen en verzenden van dit E-mail bericht de nodige zorg
besteed. Desondanks is het mogelijk dat dit bericht onvolledig is, onjuistheden
bevat, niet voor u is bestemd of te laat wordt ontvangen. PGGM aanvaardt
daarvoor geen enkele aansprakelijkheid.
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de
geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is
verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van
deze informatie aan derden is niet toegestaan. Indien u niet de beoogde
ontvanger van dit bericht bent, gelieve u de afzender per omgaande van de
onjuiste adressering/ontvangst op de hoogte te stellen en dit bericht, met
inbegrip van eventuele bijlagen, uit uw systeem te wissen.
PGGM staat er niet voor in dat dit bericht en/of bijlage(n) op generlei wijze
schade kan veroorzaken, hoegenaamd ook, en aanvaardt daarvoor geen enkele
aansprakelijkheid.
================================================================================
PGGM has taken all reasonable care by the editing and the sending of this E-mail
message. Nevertheless it might happen that this communication is incomplete or
incorrect, that you are not the intended recipient or that this message will be
received late. PGGM does not accept any liability for this.
The information contained in this communication is strictly confidential and may
be legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you are
not the intended recipient you are hereby notified that any disclosure, copying,
distribution or taking any action in reliance on the contents of this
information is strictly prohibited and may be unlawful. If you are not the
intended recipient of this message, you are requested to inform the sender by
return of the incorrect address/receipt and to delete it from your system,
including the attachments, if any.
PGGM does no warrant that this message and/or any attachment can in any way not
cause any damage at all and does not accept any liability for such circumstance.
================================================================================

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, it could be better If I generate Excel report from the
PL/SQL code.
With Java as interface, am facing so many problems. Performance came down
drastically.
Can any one give me solution in this reg.

Thanks 'n' Regards.
Chandra.

----- Original Message -----
From: "utPLSQL-Info Moderator" <utPLSQL-Info-owner@yahoogroups.com>
To: <chandrareddym@...>
Sent: Friday, August 23, 2002 5:20 PM
Subject: Welcome to utPLSQL-Info


>
> Welcome to the utPLSQL-info group at Yahoo Groups.
>
> Please take a moment to review this message.
>
> The utPLSQL-info group was set up to facilitate conversations about
utPLSQL, a unit testing framework for
> the Oracle PL/SQL language. You can find the latest version of utPLSQL
> in the Files section of the Yahoo Groups "home" for the utPLSQL-Info
group, or by visiting:
>
> http://oracle.oreilly.com
>
> To learn more about the principles behind utPLSQL,
> please check any of the following sources for
> information on Extreme Programming:
>
> www.xprogramming.com
> www.extremeprogramming.com
> and Extreme Programming Explained, an excellent text by Kent Beck.
>
> Steven Feuerstein adapted the ideas on unit testing embodied
> in projects like Junit for Java to PL/SQL.
>
> To start sending messages to members of this group, simply send email to:
>
> utPLSQL-Info@yahoogroups.com
>
> If you do not wish to belong to utPLSQL, you may
> unsubscribe by sending an email to
>
> utPLSQL-Info-unsubscribe@yahoogroups.com
>
>
> Regards,
>
> Steven Feuerstein, utPLSQL creator
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

Hi Albert and Chris,

I checked this and it worked :o).

Thanks for Your help.

Cheers

Juergen
------------------------------------------------
chris@... wrote the following message :
------------------------------------------------
--- In utPLSQL-Info@y..., Juergen Aschenbrenner <jasche@s...> wrote:
> 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 guess, but I am not sure that there is a bug in the
*utassert.eqqueryvalu* procedure

The trouble is that when utassert.eqqueryvalue constructs a cursor
based on the query "select count(rowid) from bar_t", it doesn't
recognise the table bar_t which exists in the tested schema.

Similarly to Albert, I suggest:

    connect as <schema>;
    grant select on bar_t to utplsql;
    connect as utplsql;
    create synonym bar_t for <schema>.bar_t;

Chris


------------------------ Yahoo! Groups Sponsor ---------------------~-->
4 DVDs Free +s&p Join Now
http://us.click.yahoo.com/pt6YBB/NXiEAA/RN.GAA/saFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
utPLSQL-Info-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/






================================================================
StarOffice.com, Your Free StarOffice Portal.

--- In utPLSQL-Info@y..., Juergen Aschenbrenner <jasche@s...> wrote:
> 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 guess, but I am not sure that there is a bug in the
*utassert.eqqueryvalu* procedure

The trouble is that when utassert.eqqueryvalue constructs a cursor
based on the query "select count(rowid) from bar_t", it doesn't
recognise the table bar_t which exists in the tested schema.

Similarly to Albert, I suggest:

    connect as <schema>;
    grant select on bar_t to utplsql;
    connect as utplsql;
    create synonym bar_t for <schema>.bar_t;

Chris

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 guess, but I am
not sure that there is a bug in the *utassert.eqqueryvalu* procedure

Cheers

Juergen
------------------------------------------------
albert.tumanov@... wrote the following message :
------------------------------------------------
You should grant to UTPLSQL and create synonyms:
   connect as <schema>;
   grant execute on del_bar to utplsql;
   grant execute on ut_del_bar to utplsql;
   connect as utplsql;
   create synonym del_bar for <schema>.del_bar;
   create synonym ut_del_bar for <schema>.ut_del_bar;

If you search hard enough, you can find reference to this
in the readme file:
"In Oracle8i, the Invoker Rights model is used to allow all of utPLSQL
code to run under the authority of the invoker, not the owner/definer.
In earlier versions, the Definer Rights model is followed. So if you
define utPLSQL in a central schema and then share it with others via
GRANTs and synonyms, you may need to grant additional authority to the
utPLSQL schema."

Albert.

--- In utPLSQL-Info@y..., Juergen Aschenbrenner <jasche@s...> wrote:
>
> 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 bar_t
> /
> create table bar_t (id number primary key, name varchar2(25))
> /
> create or replace procedure del_bar(p_id number)
> is
> begin
>  delete from bar_t
> 	 where id = p_id;
> end del_bar;
> /
> create or replace package ut_del_bar
> is
>  procedure ut_setup;
>  procedure ut_teardown;
>  procedure ut_del_bar;
> end;
> /
> create or replace package body ut_del_bar
> is
> procedure ut_setup
> is
> begin
>  delete from bar_t;
>  insert into bar_t (id, name) values (1, 'Bunny');
>  insert into bar_t (id, name) values (2, 'Poldy');
>  insert into bar_t (id, name) values (3, 'Molly');
> end ut_setup;
>
> procedure ut_teardown
> is
> begin
>   null;
> end ut_teardown;
>
> procedure ut_del_bar
> is
> begin
>  del_bar(2);
>  utassert.eqqueryvalue('del_bar test',
>
	 'select count(rowid) from bar_t',
>
	 2);
> exception
>  when others then
> 	 utassert.this('del_bar :'||sqlerrm(sqlcode), FALSE);
> end ut_del_bar;
>
> end;
> /
>
> sql>exec utplsql.test('DEL_BAR',owner_in=>'FOO');
> .
> >  FFFFFFF   AA     III  L      U     U RRRRR   EEEEEEE
> >  F        A  A     I   L      U     U R    R  E
> >  F       A    A    I   L      U     U R     R E
> >  F      A      A   I   L      U     U R     R E
> >  FFFF   A      A   I   L      U     U RRRRRR  EEEE
> >  F      AAAAAAAA   I   L      U     U R   R   E
> >  F      A      A   I   L      U     U R    R  E
> >  F      A      A   I   L       U   U  R     R E
> >  F      A      A  III  LLLLLLL  UUU   R     R EEEEEEE
> .
> FAILURE: "DEL_BAR"
> .
> > Individual Test Case Results:
> >
> FAILURE - del_bar :ORA-00942: table or view does not exist
> >
> >
> > Errors recorded in utPLSQL Error Log:
> >
> > NONE FOUND
>
> PL/SQL procedure successfully completed.
>
> any hints
>
> Juergen
>
>
> ================================================================
> StarOffice.com, Your Free StarOffice Portal.





================================================================
StarOffice.com, Your Free StarOffice Portal.

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 bar_t
/
create table bar_t (id number primary key, name varchar2(25))
/
create or replace procedure del_bar(p_id number)
is
begin
	 delete from bar_t
		 where id = p_id;
end del_bar;
/
create or replace package ut_del_bar
is
	 procedure ut_setup;
	 procedure ut_teardown;
	 procedure ut_del_bar;
end;
/
create or replace package body ut_del_bar
is
procedure ut_setup
is
begin
	 delete from bar_t;
	 insert into bar_t (id, name) values (1, 'Bunny');
	 insert into bar_t (id, name) values (2, 'Poldy');
	 insert into bar_t (id, name) values (3, 'Molly');
end ut_setup;

procedure ut_teardown
is
begin
 	 null;
end ut_teardown;

procedure ut_del_bar
is
begin
	 del_bar(2);
	 utassert.eqqueryvalue('del_bar test',
			 'select count(rowid) from bar_t',
			 2);
exception
	 when others then
		 utassert.this('del_bar :'||sqlerrm(sqlcode), FALSE);
end ut_del_bar;

end;
/

sql>exec utplsql.test('DEL_BAR',owner_in=>'FOO');
.
>  FFFFFFF   AA     III  L      U     U RRRRR   EEEEEEE
>  F        A  A     I   L      U     U R    R  E
>  F       A    A    I   L      U     U R     R E
>  F      A      A   I   L      U     U R     R E
>  FFFF   A      A   I   L      U     U RRRRRR  EEEE
>  F      AAAAAAAA   I   L      U     U R   R   E
>  F      A      A   I   L      U     U R    R  E
>  F      A      A   I   L       U   U  R     R E
>  F      A      A  III  LLLLLLL  UUU   R     R EEEEEEE
.
FAILURE: "DEL_BAR"
.
> Individual Test Case Results:
>
FAILURE - del_bar :ORA-00942: table or view does not exist
>
>
> Errors recorded in utPLSQL Error Log:
>
> NONE FOUND

PL/SQL procedure successfully completed.

any hints

Juergen


================================================================
StarOffice.com, Your Free StarOffice Portal.

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 to allow for installation on Oracle7 and
Oracle8.

Added override_package_in argument to utPLSQL.test so that you can
bypass the standard ut_ naming conventions for testing. This is
useful when your package name's length is 28 or above. By passing in
the override package name, you can avoid the name limitation.

New utOutput package and associated assertions to validate
DBMS_OUTPUT text that is generated from within a program.

Added utplsql.run and utplsql.runsuite to run a named test package
directly, and not correlate it via the name of the program being
tested.

There have also been various updates to the documentation to describe
features which have previously gone undocumented.

Chris

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 the *AUTHID
CURRENT_USER*
sequence in the package header declaration. Since this is a feature of vers. 8
and higher
I commented it out and installed the missing package bodies manualy.

I did install utplsql is its own schema called *ut* and run a simple
test(*betwnstr*)
also installed in ut. It worked well. When I set up a test *ut_bar* for the
function
*bar* within the schema *foo* I got *Program named "BAR" does not exist.*
returned.

The same set up worked pretty well on a vers. 8.1.7.0.0 data base.

Any hints

Cheers

Juergen

sql> connect foo/foo@...;
sql>Connected
sql>set serveroutput on size 1000000;
sql>exec utconfig.showconfig;
=============================================================
utPLSQL Configuration for FOO
Directory:
Autcompile? N
Manual test registration? N
Prefix =
=============================================================

PL/SQL procedure successfully completed.
sql>exec utplsql.test('BAR');
Program named "BETWNSTR" does not exist.

PL/SQL procedure successfully completed.
sql>connect ut/ut@...
Connected.
sql>set serveroutput on size 1000000;
sql>exec foo.ut_bar.ut_setup;

PL/SQL procedure successfully completed.

sql>


================================================================
StarOffice.com, Your Free StarOffice Portal.

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 this before? I have to evaluate if this is possible and
reasonable, but I think it is, since OWB mappings are, behind the
scenes, just PL/SQL stored procedures.

Any clue/advice?

Thanks in advance! :-)

---------- Forwarded message ----------
Date: Mon, 17 Jun 2002 15:25:31 -0500
From: Larry Winkler <lawrence.winkler@...>
To: Chris Rimmer <chris@...>
Subject: Re: [utPLSQL-Info] Testing stored Java procedures (fwd)

Junit.jar installs without problem in our Oracle 8.1.7 database, and after
appropriate java permissions are set, run flawlessly -- all within a given
schema.

However, I have been unable to resolve references to junit classes when
called from another schema. I get a ORA-01742 error (unterminated comment)
error -- quite strange since I'm loading java classes not source. Likely to
be a permissions problem. I loaded junit classes with the -grant option
which should the named user to access the junit classes.

Some work yet in order.



At 09:35 AM 6/12/2002 +0100, you wrote:
>---------- Forwarded message ----------
>Date: Tue, 11 Jun 2002 12:33:50 -0500
>From: Larry Winkler <lawrence.winkler@...>
>To: Chris Rimmer <chris@...>
>Subject: Re: [utPLSQL-Info] Testing stored Java procedures
>
>I'm thinking about the same thing. I'm going to make a presentation on
>Monday to a group re: utplsql and would like to show how to test plsql via
>Junit.
>
>But, I've got a lot to learn. I think there are two basic approaches: 1)
>Run Junit on the client as normal, referencing the plsql package to be
>tested via SQLJ, 2) Install the non-gui classes of junit.jar into Oracle
>8i/9i and build the java test classes on the database server, and running
>just the GUI portion of junit.jar on a client.
>
>But, need to get SQLJ java preprocessor to work first. (using Jdeveloper9i
>as IDE).
>
>Any experience out there?
>
>At 11:55 AM 5/30/2002 +0100, you wrote:
> >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 it even possible?
> >
> >The reason I am asking is that it crossed my mind that utPLSQL's database
> >specific features could make it more useful for doing this than just
> >JUnit itself. Maybe it could be used as a wrapper around JUnit?
> >
> >Ideas?
> >
> >Chris
> >
> >--
> >Chris Rimmer
> >NOMINET UK
> >+44 1865 332334
> >chris@...

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, rather than caller.


-----Original Message-----
From: a_tumanov [mailto:albert.tumanov@...]
Sent: 17 June 2002 12:05
To: utPLSQL-Info@yahoogroups.com
Subject: [utPLSQL-Info] Under which schema should I put test packages ?


*** WARNING - this email originates from the Internet ***

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 my schema,
but that is not good (there is no such grant in production,
so some programs that work in development will fail in production,
etc).

What's the best practice ?
Should I put UT_* packages under UTPLSQL schema (or any specially
made schema) and grant to that schema ?
But this does not help, because tests are executed using caller
privileges. And if I run test this new schema,
I need to grant this schema all the privileges that the tests would
need (tedious).

Am I missing something ?

Albert.



To unsubscribe from this group, send an email to:
utPLSQL-Info-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




***********************************************************************
INVESCO UK can accept no responsibility for the nature of
this e-mail.  If you have grounds to suspect that it is offensive
or non-business related it should be deleted immediately.  If
you require an incoming Internet e-mail to be checked for
content on your behalf please forward to the designated
business mail parking area.  If you wish to report the receipt
of an offensive e-mail contact the IT Security section within
London or Henley.  It is an INVESCO UK policy that all
Information Systems must be used for business related purposes.
In order to protect the company's image and all personnel
INVESCO UK Information Systems will be subject to monitoring.
Disciplinary action will be taken against anyone who stores,
distributes or displays inappropriate material.
***********************************************************************


*****************************************************************
The information in this email and in any attachments is
confidential and intended solely for the attention and use
of the named addressee(s). This information may be
subject to legal professional or other privilege or may
otherwise be protected by work product immunity or other
legal rules.  It must not be disclosed to any person without
our authority.

If you are not the intended recipient, or a person
responsible for delivering it to the intended recipient, you
are not authorised to and must not disclose, copy,
distribute, or retain this message or any part of it.
*****************************************************************

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 my schema,
but that is not good (there is no such grant in production,
so some programs that work in development will fail in production,
etc).

What's the best practice ?
Should I put UT_* packages under UTPLSQL schema (or any specially
made schema) and grant to that schema ?
But this does not help, because tests are executed using caller
privileges. And if I run test this new schema,
I need to grant this schema all the privileges that the tests would
need (tedious).

Am I missing something ?

Albert.

---------- Forwarded message ----------
Date: Tue, 11 Jun 2002 12:33:50 -0500
From: Larry Winkler <lawrence.winkler@...>
To: Chris Rimmer <chris@...>
Subject: Re: [utPLSQL-Info] Testing stored Java procedures

I'm thinking about the same thing. I'm going to make a presentation on
Monday to a group re: utplsql and would like to show how to test plsql via
Junit.

But, I've got a lot to learn. I think there are two basic approaches: 1)
Run Junit on the client as normal, referencing the plsql package to be
tested via SQLJ, 2) Install the non-gui classes of junit.jar into Oracle
8i/9i and build the java test classes on the database server, and running
just the GUI portion of junit.jar on a client.

But, need to get SQLJ java preprocessor to work first. (using Jdeveloper9i
as IDE).

Any experience out there?

At 11:55 AM 5/30/2002 +0100, you wrote:
>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 it even possible?
>
>The reason I am asking is that it crossed my mind that utPLSQL's database
>specific features could make it more useful for doing this than just
>JUnit itself. Maybe it could be used as a wrapper around JUnit?
>
>Ideas?
>
>Chris
>
>--
>Chris Rimmer
>NOMINET UK
>+44 1865 332334
>chris@...
>--
>
>
>
>To unsubscribe from this group, send an email to:
>utPLSQL-Info-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Lawrence Winkler
Doit/Application Technology
W:      5-4610
E:      lawrence.winkler@...
          winkllj@...

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 :-)).  However, I have only ever used the
framework in a small scale project with myself as the main (now
only...) developer.  This might give the impression that it isn't
suitable for enterprise environments.  Is there anyone out there
who'd be willing to contribute 10 minutes or so to it to describe how
they've used utPLSQL in a large multi-developer project?

Chris

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.
Sorry, after just two month I am still an oracle newbee.

If You Steve or somone else has some scripts how to handle eqcoll/api I would be
very gratefull for posting them.

Thanks for Your help

Juergen

CREATE OR REPLACE PACKAGE BAR AS

TYPE t_emps IS TABLE OF EMP%ROWTYPE
	 INDEX BY BINARY_INTEGER;

TYPE t_dept IS TABLE OF DEPT%ROWTYPE
	 INDEX BY BINARY_INTEGER;

PROCEDURE get_emps(
	 p_deptno IN DEPT.DEPTNO%TYPE,
	 p_emps  OUT t_emps
);

END BAR;
/
CREATE OR REPLACE PACKAGE BODY BAR AS

PROCEDURE get_emps(
	 p_deptno IN DEPT.DEPTNO%TYPE,
	 p_emps  OUT t_emps
) IS
	 v_emp EMP%ROWTYPE;
	 CURSOR c_emp_by_dept IS
		 SELECT *
			 FROM EMP
			 WHERE DEPTNO = p_deptno;
BEGIN

	 OPEN c_emp_by_dept;
	 LOOP

		 FETCH c_emp_by_dept INTO v_emp;
		 EXIT WHEN c_emp_by_dept%NOTFOUND;
		 p_emps(p_emps.COUNT) := v_emp;
	 END LOOP;

	 CLOSE c_emp_by_dept;
END get_emps;
END BAR;
/
CREATE OR REPLACE PACKAGE UT_BAR AS

	 ut_emps1 BAR.t_emps;
	 ut_emps2 BAR.t_emps;

	 PROCEDURE ut_setup;
	 PROCEDURE ut_teardown;
	 PROCEDURE ut_get_emps;
END UT_BAR;
/
CREATE OR REPLACE PACKAGE BODY UT_BAR AS

	 PROCEDURE ut_setup
	 IS
	 BEGIN
		 NULL;
	 END;

	 PROCEDURE ut_teardown
	 IS
	 BEGIN
		 NULL;
	 END;

	 PROCEDURE ut_get_emps
	 IS
		 v_emp EMP%ROWTYPE;
		 CURSOR c_emp_by_dept IS
			 SELECT *
				 FROM EMP
				 WHERE DEPTNO = 20;
	 BEGIN

		 utassert.this(
			 ':o) Dummy', TRUE
		 );
		 BAR.get_emps(20,ut_emps1);

		 OPEN c_emp_by_dept;

		 LOOP

			 FETCH c_emp_by_dept INTO v_emp;
			 EXIT WHEN c_emp_by_dept%NOTFOUND;
			 ut_emps2(ut_emps2.COUNT) := v_emp;

		 END LOOP;

		 CLOSE c_emp_by_dept;

		 utassert.eqcollapi(
			 ':o) BAR',
			 'UT_BAR.ut_emps1',
			 'UT_BAR.ut_emps2'
		 );
	 END ut_get_emps;
END UT_BAR;
/

when I run the test I got the following:

sql>exec utplsql.test('BAR');
.
>  FFFFFFF   AA     III  L      U     U RRRRR   EEEEEEE
>  F        A  A     I   L      U     U R    R  E
>  F       A    A    I   L      U     U R     R E
>  F      A      A   I   L      U     U R     R E
>  FFFF   A      A   I   L      U     U RRRRRR  EEEE
>  F      AAAAAAAA   I   L      U     U R   R   E
>  F      A      A   I   L      U     U R    R  E
>  F      A      A   I   L       U   U  R     R E
>  F      A      A  III  LLLLLLL  UUU   R     R EEEEEEE
.
FAILURE: "BAR"
.
> Individual Test Case Results:
>
SUCCESS - :o) Dummy
>
FAILURE - EQCOLLAPI ":o) BAR SQLERROR: ORA-06550: line 47, column 40:
PLS-00302:
component 'NTHVAL' must be declared
ORA-06550: line 47, column 20:
PL/SQL: Stat
ement ignored" Result: Collection "UT_BAR.ut_emps2" does match UT_BAR.ut_emps1".
>
>
> Errors recorded in utPLSQL Error Log:
>
> NONE FOUND

PL/SQL procedure successfully completed.

sql>
------------------------------------------------
steven@... wrote the following message :
------------------------------------------------
At 11:25 AM 6/3/2002 +0000, you wrote:

>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 table and to execute
>queries on both
>tables and match the returned results (e.g. eqquery)
>
>Or, to construct a second collection out of the table data and compare
>both collections
>by using eqcoll or eqcollapi.
>
>I tried already the second aproach but it didn't worked out. Either buggy
>or simply to
>complicated for my limeted oracle skills.

Could you give me a sense of what sorts of problems you had with
eqcoll/api? They should work, and either of the two approaches sound
reasonable; your choise should probably be made based on what is
easiest/most familiar to you.

Thanks, SF




================================================================
StarOffice.com, Your Free StarOffice Portal.

Albert,

> -----Original Message-----
> From: a_tumanov [mailto:albert.tumanov@...]
> Sent: 05 June 2002 08:37
> To: utPLSQL-Info@yahoogroups.com
> Subject: [utPLSQL-Info] Re: How to test high-level module
>
>
> 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 imagine "workaround": ALWAYS use
> synonyms when calling something ! For doing real work, those synonyms
> will point to real functions; when testing, redirect those to "mock"
> functions. But this is bad solution, as it requires to rewrite all
> the code and also imposes additional unneeded overhead for production
> code (looking up the synonyms).
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 that is calling the function that you want to, for want of a
better word, "Tumanov". :-)

Whether your procedure is in a different schema will depend on your
organisation.  I'm my organisation (Nottingham City Hospital) we have
an application schema "hiss", and we have a development database.
Except for some lazy developers who work as the application schema
user (yes, it's a pet hate) we write and unit-test code as ourselves
and only update the application schema once the module has been
unit-tested.

So if I am cwright3 and write procedure cwright3.proc, which calls
existing programs called_proc and called_func, but which I don't want
to call for testing (perhaps they insert), I can create
cwright3.test_called_proc and cwright3.test_called_func and
CREATE SYNONYM called_proc FOR cwright3.test_called_proc and
CREATE SYNONYM called_func FOR cwright3.test_called_func which will
be referenced on recompilation of cwright3.proc.

It's limited in its use, but is the cleanest method.

It raises some interesting possibilities such as creating a test
function which returns a whole series of different return codes
to test a procedure's error code handling.

( I hold my hand up here and admit that I have neither thought of
   nor used this method before.   )

>
> Unfortunately, using preprocessor is not good solution either (for
> me). Some people are already using preprocessors for other purposes,
> like using the same source for storing multiple (slightly different)
> versions for each production site. In this case, chaining another
> preprocessing step adds a lot of mess.

Well if Rimmer, Synonym Tumanov and Recompilation Tumanov were all
implemented you'd have your pick, wouldn't you?

Colin Wright
Nottingham
c.d.wright@...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.368 / Virus Database: 204 - Release Date: 29/05/2002