Re: Senior Oracle DBA now Learning InformixbyRequestofCompany

> >Tambi Dude said: > > > > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > > news:mailman.538.1165996223.29126.informix-list@iiug.org... > >> > >> Mark Townsend said: > >> > >>> but here are Oracle we are all > >>> very proud of PL/SQL. It's a great language. > >> > >> For what? As an application developer, I hated it. As a DBA I avoided >it > >> like the plague. > >> > >> What is this great language good for? > > > > It is indeed a great language. I can't believe some folks are so biased. > >I notice you're not supplying any potential use for it, though. :o) > As an app developer, the basic primatives of the language blows. While I already mentioned the looping syntax, what about how you call "sub programs"? aka procedures and functions? It looks like you have to pass by reference, yet if your first parameter is CHAR(4), you have to create a data type char4 as CHAR(4) and then in your procedure input the first variable as a type char4. Like I said, its a kludge. Just like new era. ;-) _________________________________________________________________ Visit MSN Holiday Challenge for your chance to win up to $50,000 in Holiday cash from MSN today! http://www.msnholidaychallenge.com/index.aspx?ocid=tagline&locale=en-us