Search results for query: *

I want to create a case-insensitive index. I found an exemple on the net, but this doesn't seem to work. Here's my case: SQL> create table books (title varchar2(10),price number(2)); Table created. SQL> desc books Name Null? Type...

Due to 'accident' we lost the file "owsctl" (Oracle Web Appl Server), version 3.0 for AIX platform, needed for Oracle APPS 11 (not 11i). Can someone please send me this file ? We can't restore it in short term. You can send it to: mockenrue2000@yahoo.com I will update the thread as...

We have custom messages defined in Oracle APPS 11. Each message is defined in 2 languages: US and D. After generating the message files US.msb and D.msb we want to upload the D messages on another server using the FNDMDGEN utility with the RUNTIME_TO_DB option and the correct D parameter...

Problem: Query retrieves one record, but when I use the exact same query as subquery the master query returns no rows. Example with EMP table: ---------------------------- SQL> select e.job 2 , e.mgr 3 , e.sal 4 , e.comm 5 , e.deptno 6 from emp e 7...

Does anyone know some good articles on deadlocks (not wait locks) in Oracle on the web ? DBA frequently reports listings like this: >> *** 2003.04.17.09.16.54.000 *** SESSION ID:(354.144) 2001.04.17.09.16.54.000 DEADLOCK DETECTED Current SQL statement for this session: UPDATE ... ----- PL/SQL...

I have successfully installed 8i Personal Edition rel 3 (8.1.7) on a stand-alone Windows98 PC. I can start instance and database, however only when using the INTERNAL login. According to Oracle documentation the preferred login is: connect / as sysdba However doing so results in...

I have a rather straightforward version 4.5 form with two base table blocks, say block A (single row) and block B (multi row). No relation exists between the blocks. What I want is when having queried a row of block A, the rows of block B must be queried automatically, and focus must remain on...

Hello forum, We have an application built with Forms 6i using Headstart for Oracle Applications on a 8i database (8.1.7) and AIX unix platform. Initially all worked fine until we had a crash of the AIX server. After that time, we have problems regarding commit of rows. Our forms say "X...

I have a 6i form with a button that performs a GO_BLOCK statement to navigate to another block. When omitting a required field before pressing the button, Forms detects this but the error message seems incomplete: 'Call to procedure "&P1" failed' I can circumvent this by preceding...

Hi, I have a form (4.5) that has been generated with Designer 1.3.2 and Headstart for Applications 1.2. It has a Query-Find window that works o.k. in normal mode. In Query-Only mode however, info message "No records exist here" is raised when selecting one of the rows in the Find...