Recent content by thebull1

We are experiencing a situation where we have developed our application using oracle forms connecting to an oracle database. We are now deploying the application through the web but now we are experiencing the following error. "FRM-92060: Failed to Connect to the server. Bad machine...

Hi there! Thanks for your speedy response. Either view or display will do. You can choose the easier one. Thanks, in anticipation too :-)

Thanks SantaMufasa. I will rephrase my question with a better example, then aks my question:- In the example below, we take the employee name (ename) and the department number (deptno) and display the salary of the employee by their department. SELECT * FROM (SELECT ename...

Hi All? I am working on a matrix query whereby I do not want to specify the columns ie Select job_id, (row 1..n of table emp should be the columns) from emp; Old way ------------ Select job_id, decode (dept id,10) "Dept 10",... decode (dept id,n) "Dept n", from emp; Basically you have an...

Hi Jennifer? Is it core_id = '0' or core_id = 0. The datatype of the field is important.

WORKS LIKE MAGIC... THANKS A LOT MATT!!

That works Matt.. Thanks a lot. The only problem is that absolute path "c:\whatever.html". Is there a way Ican pick my current working Directory. I would like to put the help files inside the application directory and reference from there. This could be in any directory depending on where the...

Hi All? I have a HTML Help application that I want to run from PowerBuilder 6.5 (a bit archaic I admit). The run command works well for other applications like winword, excel, notepad, etc, but will not open my HHT.HTML file using Explorer. Any ideas please?

Ooops... I will aks the Admin about the datafile. But the same users have no problem using a PowerBuilder application here that connects to the same database. Or the corrupt/deleted datafile has nothing to do with that?

Hi All? I am a programmer and have been liasing with my System Admin to try and resolve some issue Im having. Im unable to log into my Oracle 8 database from SQLPLUS using any of the users. It just hangs, even the user SYSTEM. The all just hang when I attempt to connect. This user SYSTEM is...

Thanks All for your kind assistance.. I have since extracted a previous copy fo the database from a dump,and am slowly reconstructing all the changes that I had made since the previous extraction. Important lessons learn, and like Musafa advised, Iwas S.O.L. (Surely Out Of Luck). I will be...

Bravo. I ahve now managed to bypass that previous hiccup, and gone back to what KenCunningham had proposed earlier. I wans only able to alter database backup controlfile using a .CTL file that did not exist (see script). After that I issued alter database open resetlogs which now has a new...

Things get worse here!! I cannt even mount the database now.. Think something is wating my database at night.... SQL> startup mount ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shutdown abort ORACLE instance shut down. SQL> startup mount ORACLE instance started...

Things get worse here!! I cannt oeven mount the database now.. Think something is wating my database at night.... SQL> startup mount ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shutdown abort ORACLE instance shut down. SQL> startup mount ORACLE instance started...

Hi All? Did I miss soething from Ken's instruction? This command is returning a syntax error... SQL> connect / as sysdba Connected. SQL> shutdown abort ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size...