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).
Received on Sun May 07 2006 - 20:45:30 CDT
