In very simple words and in one line they are at the far shores of the river. On the bright side you have got the database with all of its miracle powers that you see Oracle proclaims about on its website. And well on the other side…………. May be I think one more time before saying anything. But I really thought about it a lot. I mean just look at the features of the Oracle Database and then look at the development tools that it had; you will definitely get confuse enough and will start thinking something else. I mean from SQL Developer to Forms Builder to Application Express; all have only one problem and that is they are not up to the task.
I wrote about SQL Developer in my earlier post and there is no need to say anything it anymore. There is nothing wrong with its features they seem to be good. But when you start it; the way it will consumes you machine's resources is too overwhelming. May be using something else then Java may solve the problem. There is nothing wrong with Forms and Reports Developer but they are too old to be used. After 6i nothing has been done to improve them; just a web interface which hangs more and works fewer; again thanks to Java. Although I am new to application express and just a couple of days ago I loved everything of it but till yesterday. Although very frequently it happens that your LOV may stop working but yesterday I discovered something that made me annoyed more then what when I get over my end-user's response. You cannot use updatable Primary keys on tables in application that you are planning to build using Oracle Application Express. Primary keys must be auto update either using a trigger or some PL/SQL function. Don't get confuse that it offers an option because that does not work. Updates will not work. There are works around on internet but in my case all of them failed. The problem is in Application Express 3.0; I don't whether it got fixed in 3.1 or not.
No comments:
Post a Comment