Search results for query: *

Dears, I'm using utl_file.put_line to log the steps of a PL/SQL into a file on the server. The first put_line statment is performed before any other action. And then the job logs the other steps, untill the end. The feature works fine, but I'm not able to see the results (file size is 0)...

Hi, I heard about Excel doctype and that it requires some third party installation. I have got poor privileges on the database, it means I have no UTL_FILES and no access to the server, only Oracle client. Will I be able to generate Excel files to LOB with standard Oracle packages ? Or is...

Hi, I have a distribution list, and each destinator should receive an attachement. The attachement is a text generated on the fly from the database and then stored in a LOB. But due to mailbox limitation, I have to compress the text before to send it, with standard compression like zip or rar...

Hi All, I need a code assistant to avoid repeating the same basic application development several times, I'll detail here below. I have to provide several access to users, and they are basically all the same user manipulates data through a php webpage. User can edit/insert/delete records, it...

Hi All, I have got to CGI scripts, one of them upload a file on a server, and the other one process the file then compress it with winrar in the same directory. The first script works fine, and so does the second one when it is run from the server. But when it is from the browser (CGI) the...

Hi, What is the common algorithm, and the most secured one that is shared between dbms_obfuscation_toolkit package and openssl ? try to find one to load a crypted file (using openssl) on linux, and decrypt it later on user Oracle package. Regards, Zephan

Hi All, I compiled a java program on a windows PC, it works fine in the IDE. I then copy the entire folder to a Linux server, and it works fine. But when I run the program on my PC from the command line, it does'nt work, even the syntax is the same on linux means java -cp...

Hi, I want to write a procedure (or package) and inside the code, there is a password. How to hide the entire code from other users, and if possible from the owner itself. I hear that is called wrapping. Regards, Zephan

I need it very urgently, not api just executable because I need to do simple things with it and very fastly. I found a lot of java classes and API's but it is hard for me to customize. What I need is a simple software that accepts line number and text as arguments and simply send them to the SMSC.

Hi everyone, I have a standard installation of HP-UX (11). I have got a file containing a list of values. I need a script that pops a value from the file, encrypt it, and push it in another file. What RSA features can I find in HP-UX, what are the command names and syntax ? If no RSA is there...

Hi All, I want to store encrypted data on an Oracle Database. At first, the data is stored in a PGP encrypted file, of course I own the private key. The clear text is a list of values, each value in a line. What I'm thinking about is writing two functions encrypt(value) and...

Hi All, How to find for the current user, all the referenced objects (especially tables and mviews) with the referencer if possible (on Oracle 9i 1.0.2). Regards, Zephan

Hi, Are there any package, or any other way to read from Application log, in windows 2000 event log, then to send an email on any specific event found ? Regards, Zephan

Hi, I have PL/SQL stored procedure in wich a remote SELECT is performed using a dbLink to database named remoteDB. The DBA set a timeout for inactive connections on remoteDB database. The PL/SQL is as following CREATE PROCEDUERE some_proc IS --Some declarations here BEGIN insert into...

Hi All, When I use count function in an aggregator (OWB 9i), the expression type is set by default to the counted item. Ie if I use count(some_date) the type is set to date and grayed (you cannot change it). How could I fix this. Also, I need to be able to count distinct values, I know I can use...

Hi All, I have got two huge comma separated files. The files have the same format (means the same order of fields). I want to compare between the two files and obtain a third file with the same format (comma separated and the same order of fields). Is it possible to do this by using a simple...

Hi All, When I use count function in an aggregator (OWB 9i), the expression type is set by default to the counted item. Ie if I use count(some_date) the type is set to date and grayed (you cannot change it). How could I fix this. Also, I need to be able to count distinct values, I know I can use...

Hi All, I try to use owa_opt_lock.checksum oracle SYS's function. My problem is that Oracle dont want to use the second version. The first version is : owa_opt_lock.checksum(p_buff VARCHAR2) RETURN NUMBER; and the second one : owa_opt_lock.checksum( p_owner VARCHAR2, p_tname VARCHAR2, p_rowid...

Hi All, I've got a table table1 (a varchar2(6), b date). An index idx1 on column a. When I use a clause where with IN operator Select * from table1 where a in ('X', 'Y', 'Z'); idx1 is not used event with an optimizer hint. But if I turn it to = operator. Select * from table1 where a = 'X'...

Hi All, I run SELECT db1.table1.*, table2.f1, table2.f2, table3.f3 FROM table1, table2 LEFT JOIN table3 ON t1_fk = t3_pk the query returns an error that t1_fk does'nt exist. If i revert table1 and table2 order like below : SELECT db1.table1.*, table2.f1, table2.f2, table3.f3...