Recent content by Jeronimo

I'm learning Crystal Reports v8, and am fixing some 55 old reports. The reports currently offer results based on a date, but now we want to have a range as well as being able to see a result set showing those records with null dates (which would be unposted transactions). I can do it with a...

Winnt 4.0sp6a wks In display properties\screensaver tab, is there a way to lock (or grey) screen saver informations like password protection and wait delay ? Note: I want user to be able to see these informations but not to change them ! Thanks

Hi! Suppose that a package x belongs to a schema, say SCOTT. Now, I want to copy the entire package to another schema, say LIZ. Is there any command in sql for doing so, e.g. COPY SCOTT.X TO LIZ.X ? Thanks for your help! Jeron P.S.: I don't have the SQL Loader.

Hi shetty, I have some LOCs which might be useful for you: DECLARE Lob_loc BLOB; Buffer RAW(2700); Amount BINARY_INTEGER := 2700; Position INTEGER := 1; h_var VARCHAR2(10000); BEGIN /* Select the LOB: */ owa_util.mime_header('image/gif'); SELECT imagefile INTO Lob_loc...

Hi, I want to create a HTML form where the user can upload an image file. This image file has to be stored in an ORACLE table. I am thinking about something like this: : <form action=&quot;http://myserver/put_picture.exec&quot; : method=&quot;post&quot; ...

Hi shetty, maybe this URL could help you: http://lbdwww.epfl.ch/f/teaching/courses/oracle/iweb/mw_store.htm Good luck, Jeron

Hi Nanda, it's a good idea to use the UTL_File package (see http://www.orafaq.com/faqplsql.htm). Here are some lines of code, taken from that page and slightly modified: DECLARE fileHandler UTL_FILE.FILE_TYPE; h_var VARCHAR2(20); BEGIN fileHandler := UTL_FILE.FOPEN('/tmp', 'myfile.txt'...

Hi, I want to create a directory at runtime. This is my PL/SQL code: 1 DECLARE 2 h_var VARCHAR2(20) := 'C:\images\'; 3 BEGIN 4 -- EXECUTE IMMEDIATE 'CREATE directory &quot;image_dir&quot; as ''C:\images\'' '; 5 EXECUTE IMMEDIATE 'CREATE directory &quot;image_dir&quot; as || help '...

Hi, I have some image files (tiff) which I would like to store in tables. Is this possible? If so, how? Thanks, Jeron

Hi Mike, hi yaffle thanks for your replies! Mike, I'm sorry, but it does not work. But let me describe the problem in more details: I have the following tables: create table demo_table( dummy VARCHAR2(200)); insert into demo_table values('Hello!'); create table sqlstatement_table( statement...

Hi, I have a problem concerning PL/SQL, and I want to describe it on a concrete example: Let's suppose that you have a table called &quot;Sqlstatement_Table&quot;. Here's the code for that table: CREATE TABLE Sqlstatement_Table( Statement...

Hi everybody,<br>I have a problem using the procedure UTL_FILE.GET_LINE.<br>My ORACLE version is 8i. Here's the problem:<br>I want to open a textfile which contains several lines; it looks like this:<br>item1 item2 item3 <br>item4 item5 item6 <br>item7 item8 item9 <br><br>I want to store the...