tag:blogger.com,1999:blog-21122514.post7276465489575200443..comments2024-03-23T11:05:13.046+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): What should you say to students when teaching Oracle?Dimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-21122514.post-21744466206745904932007-12-08T21:33:00.000+01:002007-12-08T21:33:00.000+01:00Hi "Anonymous",Thank you for your feedback.Before ...Hi "Anonymous",<BR/><BR/>Thank you for your feedback.<BR/><BR/>Before I do a proper reaction I prefer to know what development language you use?<BR/><BR/>Or can I somewhere see what your experience level is?<BR/><BR/>Thanks,<BR/>DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-59513873189368721312007-12-08T19:44:00.000+01:002007-12-08T19:44:00.000+01:00Hi Dimitri,What you know about application develop...Hi Dimitri,<BR/><BR/>What you know about application development is limited with Oracle and its tools such as APEX. Probably You know nothing else and never been in an application development. You are a DBA. <BR/><BR/>I am working as an application developer for an enterpise company having ~10 OLTP databases. Here is my experience shortly.<BR/><BR/>1.Working with stored procedures with dblinks makes application develoment terribly difficult and test.<BR/><BR/>2.Its nearly impossible to refactor stored procs. and maintain them.<BR/><BR/>3.Its difficult to version stored procs and apply continues integration.<BR/><BR/>4.Its impossible for two developers working on a same package.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-11099810242148843822007-11-14T15:28:00.000+01:002007-11-14T15:28:00.000+01:00Hi Dimitri, I couldn't agree more. After a decade ...Hi Dimitri,<BR/> I couldn't agree more. After a decade being an Oracle DBA, I've seen the problems derived of putting the logic outside of the database, it's far better to use stored procedures. Now I'm teaching Oracle courses and when we talk about the subject of where the code goes? I say: "on the database of course"Enrique Orbegozohttps://www.blogger.com/profile/09472047223000712373noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-39980691100557546942007-11-10T15:15:00.000+01:002007-11-10T15:15:00.000+01:00Hi Dimitri,I fully agree with you that logic and d...Hi Dimitri,<BR/><BR/>I fully agree with you that logic and data manipulation should be done as close to data as possible. I also prefer to write business logic layer in PL/SQL at DB side, and have client software as thin as possible.<BR/><BR/>Cheers, PawełPaweł Baruthttps://www.blogger.com/profile/16867021334037413869noreply@blogger.com