Search results for query: *

It worked very well! Thanks so much!

Thanks for your reply. I'm processing a data file. This file contains hundreds of thousands lines. Each line is a record of a very long number. I need to read through it the first time to count the number of records to verify if this file is valid. Since the volunm of the data, I cannot store...

hi, I'm new to C#. I need to read through a file twice, and I wonder if I can reset the pointer without close and reopen the file. Any help will be appreciated! Lydia

Wow, thanks, thanks, thanks! All are great suggestions! Now I feel like I've already been promoted to an expert of formatting an integer! I'm saving this thread for future reference. You guys are great!

PHV, I really appreciated your help, but I'm a beginner and I'm not sure how your solution will work. When I have time I'll try your solution and I'm sure it's a better solution. Thanks!

Thanks, 123fakest. This is exactly what I'm doing.

Thanks, I think I found a way to solve the problem. It may not be the best way, but it will work. Thanks.

Hi, I need to format a dymanic integer into a string with length of 3. If the integer is 1 then the string is 001, if the integer is 999 then the string is 999. I'm not sure how to accomplish this. Can anyone help? Thanks a lot! Lydia

Thank you very much! I think all of you are right. However, I don't know who installed the patch. This is our client's server and the Oracle and the patchset were installed by their tech support. I'll pull all the strings to find out. Thanks again! Best wishes, Lydia

Okay, I'm back and our server came back online. Here's the log file from export on the server: ================================================= Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release...

Thank you all! We're having some network problems since late yesterday. I haven't been able to log onto our server. I'll keep trying today and give you the log file for the export so that you can help me to detemine what went wrong. Thanks again and happy Thanksgiving! Lydia

The full path to the export utility is H:\oracle\ora92\bin\. There's only one oracle home on the machine, and I specified the full path to the utility when I ran it. Any other ideas? Thanks, Lydia

Thanks for all your replies. When I execute the following command from DOS prompt (Oracle9i on Windows2000): exp usrid/passwd full=y file=myExp.dmp log=myLog.log The message shows the Oracle version is 9.2.0.1.0. I assume this is the version for the export utility. If I go to OEM and look up...

Hi, I'm doing an export on the server, Oracle 9.2.0.1.0. However, I received an error message like this: Table or view does not exist, ORA-error-942. Any idea what went wrong? Thanks, Lydia

Hi, I got the same error message on the SERVER with Oracle 9.2.0.1, when exporting the database. Does anybody know why? Thanks, Lydia

Can I setup a procedure or a trigger in Oracle9i so that it happens on a certain time interval, e.g. every hour or every day? If I can, how should I do it? Thanks, Lydia

Hi, I have created an EXE file and I need it to run as a service on Win2000 server. I've tried scheduled tasks, but somehow it doesn't run as service. It always stops after a while. I didn't set any stop point in the task configuration. Does anybody know why this is happening? Is there any...

Yes, it works fine without carriage returns. May I ask why you asked this question?

Hi Dima, Thanks for the reply. That's exactly what I was thinking. However, when I tried to use plain SQL statement instead of stored procedure, it worked fine. Wouldn't the sql engine interpret the SQL statement and the stored procedure the same way? (unfortuantely, I'll have to user stored...

Hi, I have some text boxes on an ASP page and there may be carriage returns in the text boxes. I tested them with regular in-line SQL statements and they work fine. However, if I turn the SQL statements into Oracle stored procedures, it will give me an error saying "Invalid SQL...