Search results for query: *

How can I connect 2 different databases via database triggers? DB1 = Oracle 9i Version 9.205 DB2 = Oracle 7.23 both databases are running above unix. DBLink doesn't work with those versions, and I want update differents tables between databases. Thanks.

How can I connect 2 different databases via database triggers? DB1 = Oracle 9i Version 9.205 DB2 = Oracle 7.23 both databases are running above unix. DBLink doesn't work with those versions, and I want update differents tables between databases. Thanks.

I have a table named TEST_TABLE COD_A NUMBER(1) FIELD_1 NUMBER(7) DESC VARCHAR2(10) I have a trigger AFTER UPDATE on FIELD_1, when I update the the field DESC via SQL, the database trigger doesn't fire, and this is fine, but if I update the field DESC via FORM, the database...

I am trying to install Personal ORACLE 8.1.6 on Windows 2000 Spk 4, my PC configuration is : Processor: Pentium IV 1.4 GHZ RAM : 256 Mb. when the installation software are running, I received an error like that : Error: "The area is not valid. There aren't superior level components for...

How can I know what patch I have installed? Which is the recomended last patch? thanks, Pablo

I use the WIN_API library, exactly the function WIN_API_SHELL.WINEXEC(:block.file_name_xls,WIN_API.SW_SHOWNORMAL,TRUE); :block.file_name_xls contain 'c:\sheet.xls' (the file exist in the root directory) I want open the excel application with the file store in the item. then, forms send me...

This thread is a rply of thread259-877570 The lewisp's solution work fine, but I want to highlight the current record with another color, but when I stay in a record with another background color activated by the trigger POST-QUERY, the current record's color don't change. Thanks. Pablo...

The developer demo show a drill down from a report, calling a new report. I want to know if is possible run a Form from report. I try the following command from a button in the report : SRW.RUN_PRODUCT(FORMS,'c:\forms\xxxx.fmx') but, I cant compilate the PL/SQL. thanks. Pablo.

I have a forms with win_api sentences, in the pc's connected directly to the oracle database the forms work fine, but in the client with terminal server, forms send me the following error's message FRM-40734 Internal error : PL/SQL error occurred Mi configuration is: Oracle9i Enterprise...

Can I send a email to the client from a database trigger? If this is possible how can I do it? thanks. Pablo

I have the Forms [32 Bit] Version 6.0.8.13.0 (Production), how I can find in metalink the patch for upgrade to 6.0.8.21.3 thanks, Pablo

How I can use a function that return a boolean value in a SELECT sentence???? I try the following: SELECT * FROM table_name WHERE boolean_function_call(parameter); the function must be return TRUE. Oracle send me the following message: ERROR at line 1: ORA-00920: invalid relational operator...

In the Client Editor (EDIT_TEXTITEM)when user is writting and press return the cursor does not jump to the next line, but it close the editor's windows. The user only can writte the text in one line. However, in the computers of developers the editor work fine, but in the client's computers we...

In the Client Editor (EDIT_TEXTITEM)when user is writting and press return the cursor does not jump to the next line, but it close the editor's windows. The user only can writte the text in one line. However, in the computers of developers the editor work fine, but in the client's computers we...

I am working with Personal Oracle, nobody connected at the same time, but when I commit the form, developer send me the following message: FRM-40654: Record has been updated by another user. Re-query to see change. ¿¿¿???

I need to know if the following is a Form's error: When I add a field into a existing block thru "Data block Wizzard" option, Forms make changes that I dont expect, for example, change the property "Database Item" to "NO" from the items that I added to the block...

I have a text item named :table.item set : UPDATE ALLOWED = YES UPDATE ONLY IS NULL = YES If the first time I enter data in the text item :table.item and commit, the second time I can't modify the item data, but if I press a button with the followin code: :table.item:='0001'; Why Forms change...

I need to know if the following is a Form's error: When I add a field into a existing block thru "Data block Wizzard" option, Forms make changes that I dont expect, for example, change the property "Database Item" to "NO" from the items that I added to the block...

When I execute a report , report 6i open the "Parameter Report Window" with the parameter "Destination Type" visible, then I select "Mail", it's works fine but Report insert into e-mail a file with extension *.eps, ¿Wich is the program for open this filetype? ¿Can...

I have a display item that must show a numeric value edited without decimals if it haven't, but Form shows the decimals anyway, What is the Format mask that I have to use?: data base value FORMAT_MASK Form 6i Edit I want ----------------- --------------------- -------------...