Re: .Net Reporting against Oracle

From: HansF <News.Hans_at_telus.net>
Date: Mon, 08 May 2006 02:21:37 GMT
Message-Id: <pan.2006.05.08.02.21.37.213580@telus.net>

On Mon, 08 May 2006 01:45:30 +0000, ianal Vista wrote:

> Larry Dooley <larrydooley_at_yahoo.com> wrote in
> news:Xns97BCDB63C30CBlarrydooley_at_216.196.97.142:

>>
>> We are on 9i but on Solaris. This is .NET so I really need an NT
>> solution. I'd already thought of DBMS JOBS
>>
>> The real key is using procs for reporting (I've done tons of reporting
>> systems, never used procs always dynamic sql passed to the oracle
>> engine). Procs for OLTP fine I've done enough of those including some
>> .NET. The real issue I see is constructing the dynamic sql and passing
>> the complex parameters into the proc. Sometimes the user sends in one
>> parameter for a particular report. At other times for the same report 3
>> or 4 will be sent in and one or two of them can be a list of variables.
>>
>> Got anythoughts on tha
>>
>>

> SQL is SQL; regardless of source (.NET, JSP, Oracle Forms, etc.) It is > just A Small Matter Of Programming (SMOP).]

True. But, as time goes on, I'm realizing that, while 'SQL is SQL', the 'consequences of SQL' may be different on different platforms.

That seems often to require a MMOT (Minor Matter of Thinking} to be done before SMOP or it is possible to end up with a SMUDGE (Small Mound of Unuseable and Deleterious Generic Excrement)

The OP's project certainly sounds like a project I'd been asked to invest in, done by a little local company. Worked like a charm in the prototype environment, too. Scaling, due to the dynamic SQL, proved to be a bit of a challenge, for all the reasons cited by Tom Kyte in his book "Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions" (http://apress.com/book/bookDisplay.html?bID=10008).

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Sun May 07 2006 - 21:21:37 CDT