Search results for query: *

Thank you guys.By the way, it's ok by setting autoflush parameter to TRUE when opening the file. Regards, Zephan

Well it seems Oracle doesn't write automatically to the file system unless autoflush is specified or flush procedure is used.

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)...

should try to use something (not very elegant like) like where table.division_id in ( SELECT '02' FROM dual where :Division = 'AA' OR :Division = 'ALL' UNION SELECT '09' FROM dual where :Division = 'BB' OR :Division = 'ALL' UNION SELECT '07' FROM dual where :Division = 'CC' OR :Division =...

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...

Thank you Kirsle, the issue was the blanks in the filepath and the security rights as you can guess.

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...

Yes. Morever it didn't work unless I put each command line argument and option between " " my $bin = 'C:\Program Files\WinRAR\winrar.exe'; system(qq{"$bin" "A $sourcefile $targetfile"}); #A for Archive, didn't work this way my $bin = 'C:\Program Files\WinRAR\winrar.exe'; system(qq{"$bin" "A"...

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...

What do you mean Dianceht, of course I used c:\path_to_app instead of /volume/path_to_app

Anni, do you like circular references ? Please take a look on thread759-1472004 it is a technological challenge for me. Regards, Zephan

You can take a look at thread822-1470134 Annihilic provided a nice solution, to my problem, which was to encrypt values separately and to store them in a file. I could load the file into the database. Then I read the values from the database using dbms_obfuscation_toolkit.desencrypt function. I...

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...

Sorry for the confusion, opensll do a lot of things and as Sam stated, crypt provides simple functions. The man page for crypt states "If two or more files encrypted with the same key are concatenated and an attempt is made to decrypt the result, only the the first of the original files is...

Even crypt doesn't do the job : Suppose the file cleartext with the content below value1 value2 value3 .... I want to get the file ciphertext with the following content : encryptedvalue1 encryptedvalue2 encryptedvalue3 Etc.

Thank you guy. Have you got an idea on how to crypt every single line independantly ?

Thank you guy, but still I dont know how to wrap the code :)

Thank you guys. Actually, I can start with a minimum level of security and enhance this later. I want to use the same feature oracle uses to hide it's own packages.