Search results for query: *

It is pretty much straite forward that if you make a conection from you application and the function or method of your application does not throgh and Exception its mean that your connection is succesful and database is Up. once you connect to Database, and dataabse is down after your Connection...

Ok First of all if you are Using Oracle version lower than 8.1.7 with windows 2000 then this is a know bug in Oracle. It has been Fixed in 8.1.7. Now talking about the two instances . It you have two services in NT Service dialog Box whose name starts with &quot;OracleService<instance_name>...

Hi All, My Application using ODBC to connect to Oracle Database, Now as I am hardcoding the values in SQL queries like this select * from table_name where column_name = 1234; Now every time I issue above SQL if column_name is different every time like select * from table_name where...

Mr Karluk, you solved my One Problem thanks a lot:), you were right we can have two databses on two different machines with same name on a network. But My other problem is that How I can Obtain a list of different SIDs on that Network. Because My application uses Oracle Database , and during...

to find out the location of your init.ora file you have to look Your Oracle Documentation. Ok now as far as changing the values of that file is a little bit risky if you dont know Oralce internals well. if you chage the values to wrong , you cannot start your Oracle Instance( oracle...

Ok I think you want to run this scripts without using SQLPlus refering your other post. Now my first question would be that why you are not using the ODBC to deal with Oralce database. I know there are methods in VB that can Execute SQL copmmands directly and if that SQL fails you can...

Yes,you can run the sql scripts without using SQLPlus , you can use server Manager to run those scripts. try this c:\oracle\ora81\bin\svrmgrl @SQLScripts.sql but change the path what ever is on your system.

Hi all, How I can get a list of SIDs on a local network, I know that Oracle Installer does that because that is why Oralce require a unique SID over a network. I need this because I need to Populate a list of Different SIDs on a Network in my Application Installer. Any help would be...

Ok Now first of all , I would recomend that you should store time in 24HRS format like this YYYY-MM-DD HH24:MI:SS Now comming to the problem , The only function I can think of that might help you is Months_Between this function return the number of months between two time vriables But...

here is an other way that, if you are familiar with oracle stored procedures and DBMS_BLOB packages , then you cna store in oracle Database as binary images regardless of format. you can use BLOB(binat loarge objects) datatypes . See the Oracle documentations in this regard. see if it helps or...

Dear mr Sem, As far as I know, if process 2 want to updated a row locked by process 1 , process 2 have to be in wait state untill process 1 say commit( release the lock). if you dont agree to me , I would appreciate a good reason :))) Faheem Rao

Dear Mr Carp your Solution looks Good but the thing is that when process 1 Locks a row , and process 2 tries to update the same locked row then process 2 will be in a wait state and the whole issue is to avoid wait state for process 2. in your solution anyhow process 2 have to be in a...

Ok can I ask you that why you want the Primary Key to be Auto increment.? Why cannot you just put the Seq.nextval in you insert statements. If you really want to do this , try to set the default value of that column to seq.nextval. I am not sure it going to work or not , but this is the...

you would not believe that I am having the same problem , but right after reading your question I come with a Solution !!! create a table in Database name it transaction_Control. When Process 1 reads that table set a flag in that table. Proces 1 Should send message to that...