Search results for query: *

Developer 9i I am trying to create a block based on a stored procedure. The stored procedure is returning a ref cursor not a pl/sql table. I used the wizard to create the block and everything seems fine. However, when I compile the form the QUERY-PROCEDURE is not created. No error message or...

I am trying to execute a Unix script in forms 9i using the HOST Builtin. My test unix script copies a file and moves another file to a subdirectory. The script works when executed from the Unix command line but is not but the form. I can run some simple commands through the form like echo...

I am using forms 9i. In my form, I am using the mouse-doubleclick trigger to display LOVs. The users want to use the Enter key to display LOVs. I tried using the key-enter trigger but it does not fire at all. I think the default ctrl-L would work for them. But I would like to know: 1. why...

I have a package (process_pkg) called by a trigger. The trigger is fired when table_hdr is updated. The process that updates table_hdr is from other databases via a db links. So, db1, db2, db3 and db4 can update the table at the same time but I want only one occurence of process_pkg running at...

When using the arrow keys to navigate records in a block, the value in the item is selected as if I want to copy and paste the value. How do I turn this off? Thanks

I have a poplist that has 5 elements. The elements are: a b c d e Developer keeps putting a Null element at the end with a return value of list216 (or listNNN). How do I get rid of the null elements. I just want a,b,c,d,e? Thanks

My status bar (where the tool tips and record count is) does not show up in a called form. Form A calls Form B. The status bar is visible when Form A starts but does not show up in Form B. When I exit Form B the status bar does not appear in Form A. Any ideas?

Hi Board, Quick question on looping. I have a tabular form where the user can select multiple records by clicking a check box. The user selects records that he wants to process. Once done selecting he presses a button to start a process. The process only affects the records that are checked...

The Environment: Forms 6i on Windows XP Oracle 8.1.7 The Issue: Users open forms using a drop down menus. If a user selects a form from the menu, I want to check to see if that form is already running. If the form is already open, I want that active form to be displayed. If not then open the...