Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DBMS_JOB
This is on a dba account and every place that can have a limite is marked unlimited (cpu,logical reads, sessions ...) I have tried the same package and commands on an other database and everything is fine so I think the database has trouble (and that is not my job). Thank you for your time, szabo.- SZABO
- Post #3
- Forum: Oracle: All versions
-
encryption
thank you, I have used translate but it's not very secure, I will look in to the package- SZABO
- Post #3
- Forum: Oracle: All versions
-
encryption
how can i encrypt a string in one procedure and decrypt it in another?- SZABO
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
DBMS_JOB
I CAN SUBMIT A JOB BUT AS SONN AS IT EXECUTES IT GOES IN THE EXEPTIONS OF MY PROCEDURE. I HAVE TRAPED ERROR NO 2394 WICH MAKES NO SENSE TO ME CAUSE MY USER HAS UNLIMITED EVERYTHING. IF I DO A DBMS_JOB.RUN IT WORKS FINE. THIS PACKAGE WAS DEVELOPED ON 8I AND WORKS PERFECT THERE,IT'S ON 8.0.5.0...- SZABO
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
dbms_job
Hello, I have created a package that manages users (add,modify ...)on a Oracle8 DB. works fine,this is how I call the procedure to add a user:<br><br>EXECUTE UserMgrProc.AddUserProc('name_xyz','passwd_xyz','dataBase_name');<br><br>I then created a package that uses dbms_job to create my users at...- SZABO
- Thread
- Replies: 1
- Forum: Oracle: All versions
