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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zephan

    UTL_FILE result before the end of the job

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

    UTL_FILE result before the end of the job

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

    UTL_FILE result before the end of the job

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

    In clause and variables within CASE statement

    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 =...
  5. zephan

    Does Oracle 10 support Excel generation?

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

    How to compress data and store them in a table?

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

    CGI Script unable to execute winrar

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

    Look for a code assistant to deal with DML

    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...
    • zephan
    • Thread
    • Replies: 1
    • Forum: PHP
  9. zephan

    CGI Script unable to execute winrar

    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"...
  10. zephan

    CGI Script unable to execute winrar

    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...
    • zephan
    • Thread
    • Replies: 4
    • Forum: Perl
  11. zephan

    Classpath and environment problem ?

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

    Encrypt values from a file on HP-UX

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

    Shared encryption method with openssl ?

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

    Shared encryption method with openssl ?

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

    Classpath and environment problem ?

    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...
    • zephan
    • Thread
    • Replies: 5
    • Forum: Java
  16. zephan

    Encrypt values from a file on HP-UX

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

    Encrypt values from a file on HP-UX

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

    Encrypt values from a file on HP-UX

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

    How to hide stored procedures from other users ?

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

    How to hide stored procedures from other users ?

    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.

Part and Inventory Search

Back
Top