Javier, While I am can be guilty as the next person of taking someone to task when it is pretty obvious that they are doing something incredibly stupid, you have no clue what it was that the OP was trying to accomplish and so your comment said much more about you than them. Since they said that they were a SQL Server developer and a relative Oracle newbie, it is entirely possible that their initial option of using a trigger was not, in fact, the correct one. If the only thing that modifies the database is the PowerBuilder front end then it could be entirely appropriate to not use a trigger.
Did the OP make a mistake? Who knows, we don't have enough evidence. Were you supremely dismissive of their choice of putting the code in the front end with no evidence of their requirements? absolutely! Using a tool you know rather than spending a lot of time with a new tool to solve an immediate problem may be suboptimal but it is not equivalent in any way to the example you gave. I will do things that I am well aware are suboptimal for the time being and then go back and fix them when there is time to do something the proper way. Sadly, sometimes you don't manage to get back to it and you end up with a longer term problem, but that is a different issue. Any experienced (let's just say 10 years or more) software professional that claims they have never done this either a) Is not very self aware b) Has been working in an environment with no time pressure their entire careers c) Has been working on trivial projects their entire careers d) Is perfect (been doing this 25 years, haven't met one like this ) e) Is trying to make cheap points at the expense of another. I don't plan on getting into a flame war with you Javier, but I thought that your post was beyond the level of discourse that that we encourage in this group. Can we be cutting? you bet! Do we cut people down just for the sake of doing it? Nope. Rob Javier Montani wrote: > hahaha "I found a work around for the problem and it is solved." . > That's a good one !!! hahaha LOL !!! > All my problems were solved doing FORMAT c:/u !!!! > Kids, don't do it in your dad's computer !!! hahaha. > > > 2009/7/29 jayadev paleri <jayadevpal...@gmail.com > <mailto:jayadevpal...@gmail.com>> > > I am using PowerBuilder - front end. Instead of trying something > in trigger , I created a function to to the work.. :) > > > On Wed, Jul 29, 2009 at 10:25 PM, ddf <orat...@msn.com > <mailto:orat...@msn.com>> wrote: > > > > > On Jul 29, 12:40 pm, jayadev paleri <jayadevpal...@gmail.com > <mailto:jayadevpal...@gmail.com>> wrote: > > Thanks for your reply David, First of all, I am not that > familiar to Oracle. > > I am working on SQLServer. Now I got a migration project to > From SQL Server > > to Oracle. > > I found a work around for the problem and it is solved. > > > > Once again thanks ... :) > > > > > > > > > > > > On Wed, Jul 29, 2009 at 8:42 PM, ddf <orat...@msn.com > <mailto:orat...@msn.com>> wrote: > > > > > On Jul 29, 12:32 am, pal <jayadevpal...@gmail.com > <mailto:jayadevpal...@gmail.com>> wrote: > > > > Can any one tell me how to call a procedure , in which I > have declared > > > > a globalPkg.RCT1. > > > > > > Eg: > > > > Procedure A > > > > > > ( RC1 globalPkg.RCT1 > > > > ) > > > > AS > > > > Begin > > > > > > ------ > > > > > > End; > > > > > > In a trigger I am trying to call this A. > > > > > > Thanks & Regards > > > > > > Jayadev > > > > > What, exactly, is RC1 supposed to be and what are you > trying to pass > > > to that variable from the trigger? > > > > > David Fitzjarrell > > > > -- > > With > > Thanks & Regards, > > Jayadev K.T.- Hide quoted text - > > > > - Show quoted text - > > And that 'work-around' is ... what? If you have a solution > it's nice > to post it so others can learn. > > > David Fitzjarrell > > > > > -- > With > Thanks & Regards, > Jayadev K.T. > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
