Search results for query: *

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

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

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

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

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

Hi, I'm working on a server, on which an Oracle instance was already installed without a tnsname.ora file or a listener.ora file. I copied these two files from one of my development machines to this server. And of course, they cannot work without giving them the correct SID and Global_DBName...

Hi, Hope this is an easy one for most of you. I got the following error. Can you help me fix it? SQL> UPDATE EU_Setpoints SET Last_Update ='1-Aug-2003 5:05:31 PM' 2 WHERE Tag_ID=1; UPDATE EU_Setpoints SET Last_Update ='1-Aug-2003 5:05:31 PM' * ERROR at...

Hi, I just finished migration from MSSQL2K to Oracle 9.2.0.1. I'm using ASP to access the database for information. After migration, all my comparison and calculations in ASP pages stopped working because of type mismatch. Apearantly, all integers that are migrated into Oracle are not...

Hi, I'm trying to install Oracle 9.2.0.1 on Windows2000 server. The first attempt was successful. When we had to change the machine name, we deinstalled Oracle, changed the machine name and attempted to install it for the second time. In the middle of running the second installation disk, it...

Hi, I'm working on a legacy database and I need to change the owner of all the objects to some new user. How do I do it in a one-step procedure? I've trie to use the following "EXEC sp_changeobjectowner (select name from sysobjects), 'new_user'" However, the query analyzer won't...

Hi, I'm very new to OMWB. Just installed it a couple days ago and tried to migrate a MSSQL database to Oracle. After the first time I ran it, it seemed to be successful, but I couldn't see any tables in the destination database using OEM. When I tried to run it the second time (or any time...

Hi, I need to change the default Max Length of column name from 30 to 50. I tried to change it in sys.col$ table, but I got an error message saying "object necessary for warmstarting database cannot be altered." Does anybody know how to change it? Thanks, Lydia

Hi, I got this error message when I tried to connect to Oracle from a midware software, which transfers data from OPC servers to SQL databases. According to the documentation of the middleware, there shouldn't be any problem of connecting to Oracle once the ODBC DSN is set up correctly. Of...

Hi, I have more than 50 stored procedures that need to export to Oracle from SQL. I noticed the difference in syntax between MSSQL and Oracle. Is there a way to export stored procedures from MSSQL to ORacle without creating them again in Oracle? Thanks, Lydia

Hi, I have a set of tables imported from SQL Server to Oracle. During the import process, somehow the dependencies got lost. How do I create the dependencies when tables have already been created? Thanks, Tianle

Hi, I have exported one table from MS SQL server to Oracle 9.2.0.1 on XP. The table creation was successful shown by the Export Wizard in SQL server. When I view the table in Oracle's Enterprise Manager Console, it's there with all the data. However, when I query from SQL*PLUS, it gives me a...