Re: Can a procedure contain only a SELECT statement?

From: joel garry <joel-garry_at_home.com>
Date: Thu, 25 Mar 2010 14:09:46 -0700 (PDT)
Message-ID: <ba467171-7bb6-4570-944b-a1d7b1b65857_at_y11g2000prf.googlegroups.com>

On Mar 25, 8:38 am, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> "Mladen Gogala" <n..._at_email.here.invalid> wrote in message
>
> news:pan.2010.03.25.15.10.07_at_email.here.invalid...
>
> > On Thu, 25 Mar 2010 13:01:58 +0000, Jonathan Lewis wrote:
>
> >> Would anyone care to make a technical comment on my earlier comment
>
> >> I'm still interested to hear how the front-end code can handle the
> >> output from a procedure when it doesn't have any information about what
> >> that output might look like.
>
> > Well, there must be some information.
>
> One would hope so - but in the Oracle world your front-end code has
> a formal link with the datbaase through the input types for a procedure
> and the output  type for a function, and it's a little bit difficult to
> change the
> (database) code in a way that changes the input and output types without
> realising that the front-end code might need to be modified.
>
> On the other hand, in the SQL Server world you can have a procedure
> that has no apparent feature for a formal definition of what it's going to
> output - and therefore no formal mechanism for the front-end to associate
> what it's expecting with what the database code might deliver.
>
> --
> Regards
>
> Jonathan Lewishttp://jonathanlewis.wordpress.com

I work in several languages that have implicit data conversions. This is generally considered "bad form," in that it leads to its own class of errors. I'd say the same applies to the current subject. Some things appear to become easier and more straightforward in the short term. It's a false economy.

jg

--
_at_home.com is bogus.
http://www.sfgate.com/cgi-bin/article.cgi?file=/c/a/2007/09/30/MNDTSEMSJ.DTL&tsp=business

Received on Thu Mar 25 2010 - 16:09:46 CDT