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 guess what I don't understand is, if it is a permission problem why is user appltest able to create a zero byte file in the first place? If appltest does not have permission to create a file because oratest owns /u01 then appltest would not be able to create a file at all, right? How can I...

In any directory I test this in. Here is the directory structure I am currently trying to test in and the set permissions and owner /u01 owned by oratest drwxrwsr-x /u01/product owned by appltest drwxrwsr-x /u01/product/tips owned by appltest drwxrwsrwx /u01/product/tips/forms owned by...

:control.nbt_command is a text item on the form so I can type in unix commands to execute. All files and directories have been chmod-ed to 777. I have tried to execute the script with the full path. The user does have privileges to run the script and to write to test directory. Another odd...

Also, I am not getting any error messages or codes that I see. I display the ERROR_CODE and ERROR_MESSAGE but they are 0 and NULL respectively. Here is my trigger code DECLARE l_error_txt VARCHAR2(200); l_error_code VARCHAR2(10); -- l_command VARCHAR2(100) := 'ls > testhost.txt'...

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

Where can I find documentation for using Oracle Terminal? Or is there a different utility to use for 9i. Thanks again for the help.

Thanks, I found that but I want to display the LOV only when they use the Enter key not that Tab. So Tab for navigation, Enter for the LOV. Thanks again.

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

Just to clarify the situation. insert_pkg starts on db1, db2, db3, db4. This package inserts data into table_hdr and table_dtl in my_db. When table_hdr.transmit_complete is updated, an after update trigger fires and calls my_process_pkg. I do not want my_process_pkg to run for all the dbs at...

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

Figured it out. In case anyone has encountered the problem, comment out any Set_Window_Property(forms_mdi_window,window_state,maximize); That seems to be the problem.

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?

Thanks for all the responses. Using a pl/sql table was my initial thought. I just did not know if there was any advantages to using a pl/sql table over a record group.

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