Triggers not working in Oracle 9iAS


The form triggers are not working in oracle 9i AS.
My Application server has Linux operating system with oracle form/report server installed. I am able to upload the form
in the client machine (using Internet Explorer Win98 OS). Also i can feed in the data but none of my triggers are working (WHEN BUTTON PRESSED and other validation triggers).
Can anyone suggest what to do pls.
Tnks in advance
Manoj Philip
[email protected]


Well we've tested on Linux and the trigger do work - I remember two other postings on this forumn from prople with the same problem:
Re: SQL Developer Necessities
Re: About  EXPLAIN PLAN table
In one case the problem was not re-compiling using, in the other it was something to do with the Machine setup but I don't know what the final resolution was.
The only other thing is to make sure that you are on a certified linux release for using with iAS e.g. Redhat Server 2.1 and Suse Enterprise server 7 and Untited Linux
You can check the current certifications on

November 30, -0001

Triggers not working in Oracle 9iAS

The form triggers are not working in oracle 9i AS. My Application server has Linux operating system with oracle form/report server installed. I am able to upload the form in the client machine (using Internet Explorer Win98 OS). Also i can feed in th

Select * from tab is not working in oracle 10g

select * from tab is not working in oracle 10g. But at the same time, select * from <<table>> is working. Please advise me.This works for me in Connected to: Oracle Database 10g Enterprise Edition Release - 64bit Production

Runtime.exec()  in Java not working in Oracle 10 Application Server

Hi , I am trying to call a .exe file which is in the Web Application folder . I am Using Process p = Runtime.exec("path to .exe file ") This code is working fine when used with JBOSS , but not working with Oracle Application server . Please tell

PreparedStatement not working with Oracle

Hi All, I am using preparedStatement in my JDBC code to fetch/insert values from oracle9i database. I am checking condition like if a given record does not exist then insert it else update it. First time it works when there is no row in database, how

Ctrl+Z fuctianlity is not working in oracle 10g Form

Hi I am using oracle 10g form and using Edit_TextItem to invoke Text Editor When i using CTRL+Z to undo things in editor it is not working but it works when i used Form6i. Please help me to solve this issue. i need to this functinality to be work. BR

HOST not working on UNIX 9iAS

I am attempting to HOST a command out to the middle tier. When I try this in 9iDS, it works like expected (copy c:\temp\a.txt c:\temp\b.txt). However, when I push the form up to the unix box and attempt to run the same command on the server through t

PUSH_PRED  hint is not working in Oracle 9

1) PUSH_PRED hint is not working. 2) Do we need to set any parameters of the optimizer to make it to work. Can you please guide ?Shouldn't need to set any parameters.. can you provide more information? And here's an article from Jonathan, maybe it'll

FormatTrigger on line is not working in Oracle Reports

Hi there, I am using Oracle Reports 6i and trying to format code as follows : I have three sections of data say a,b,c. 1) If there is no data returned in Section b and c, then I need to print a line just after section a ends. 2) If there is no data i

Client_ole not working on oracle forms 11g

hello,,, I have configured webutil in forms 11g ( Doc ID : 1093985.1) step by step and finally i installed webutil demo from ( Doc ID : 1272222.1) When I test it works fine , everything works fine except OLE --> write to MS Word , when i enter some t

JavaBean not working with Oracle 9i / Forms 6i

I have written a Javabean program which I invoke from Oracle Forms. The program is designed to pass a parameter from the form to the bean and get a parameter back to the form from the Javabean. The bean is called on the when-button-pressed event of a

Insert Statement is not working in Oracle Form

Hi all, I have developed a custome form from the scarch. I have one button on that for called "PROCESS" when I cick on the PROCESS button it should insert record in to one custome table. I have created custom table in custom schema and given gra

Sum function do not work in oracle reports enhanced spreadsheet format

we are using oracle reports in our oracle application server 10gr2 and we are creating enhanced spreed sheet.And the report opens in MS excel fine.But we can not apply any formula like VALUE,SUM,AVG on that report after opening it into excel

Port Triggering not working on new router

I just received Fios ActionTec rev I router and Port Triggering won't work. On my old router I could change the firewall to highest level and I was able to create port triggering to open ports so I can use Outlook to connect to Gamil accounts but on

Browser not working in Oracle Applicaiton Server

Hye,Anybody Help me? i configure Oracle Application Server fine,but from IE browser or Netscape Browser when i do any thing it give me ... " download plugins " ,so how can i solve it thanking you BrijeshHello Dear, i got the problem and it is wi

Sqlplus is not working in oracle client machine.

In one of the application server on which Oracle client is installed, While login thru unix shell script im getting below error. "Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to yo

DDE.initiate is not working in oracle forms 10g

Previously i have used DDE for uploading the data from excel to DB in oracle forms it is throwing non-oracle exception at DDE.intiate. could you please help me to solve this issue. i use the below code APPLICATION := OLE2.CREATE_OBJ('EXCEL.AP

PL/SQL does not work in Oracle 8i Personal Edition

I just installed Oracle 8i Personal Edition for Win 98. Everything works perfectly, except the PL/SQL. Then I tried to install Oracle 8i EM, but I always get the listener or adapter error. Even when I tried to start the listener from lsnrctl prompt,

Declarative transaction not working  for oracle 10g as.

Hi Friends, While migrating from sun app server to oracle 10g as, i have problem in declarative transactions. I created stateless and stateful beans with declarative transactions. Transactions were working fine till they were in sun app server enviro

Host('sqlldr') is not working in oracle forms 10g

oracle database version: oracle forms version:10g client ans server are on the same machine. when i am trying to load the file in to oracle,i wrote the when-button-pressed trigger as host('sqlldr'); when i run the form its not giving any resu

SQL Plus not working in Oracle 8i personal edition

I just installed Oracle 8i personal edition, went through all the steps. When I start SQL* Plus, I give it the SCOTT/TIGER combo, but when it tries to start up the database, it asks for another password, which I can't figurew out.<BLOCKQUOTE><fon