Welcome to Open Discussion

[Nobody/Anonymous]

Oracle Database version :  10.2g
Operating System :  developling on linux Red Hat, will be working on Sun solaris 10
JDK version : 1.5 at the moment but not using log4j at the moment
use in code : [n]trigger 
[y]procedure 
[y]function 
[y]Pakage 
still to do: log4j
Use Mode :[]In transaction
[]out-of transaction
[y]for Debug
[will be]for production

hi guys, i am going to be using log4plsql for a streams database replication project. just a note that on install i had to change the grantsys.sql script to include:
GRANT CREATE ANY VIEW TO &&1
/

thanks,
Greg B.

[Nobody/Anonymous]

OK
Thanck for you update.
Guillaume

[Stefan Mayr]

I wanted to let you know about a little bug in your install-Scripts:

If you change username/password to a combination where username != password it won't install.

Steps to fix this:
1. Edit cmd/install.sh
Change: sqlplus $ORACLE_USERSYS @grantsys.sql $LOG_USER
To:     sqlplus $ORACLE_USERSYS @grantsys.sql $LOG_USER $LOG_PASSW_USER

2. Edit sql/grantsys.sql
Change: CREATE USER &&1 PROFILE "DEFAULT" IDENTIFIED BY &&1
To:     CREATE USER &&1 PROFILE "DEFAULT" IDENTIFIED BY &&2

Now the installation works with username != password

Yours sincerely,

   Stefan