Rick,
You put BI into db using pl/sql anyways ... (well Java is another thing ..)
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 9:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: New development in Cobol or PL/SQL - please help
Babette,
If they are a Cobol shop then there is nothing wrong with using Pro*Cobol.
I disagree with your statement about using PL/SQL for
the business logic. I personally think you should put as much of that in
the database.
Rick
"Mercadante,
Thomas F" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED] <[EMAIL PROTECTED]>
ate.ny.us> cc:
Sent by: Subject: RE: New development in Cobol or PL/SQL - please
[EMAIL PROTECTED] help
11/18/2002 08:03
AM
Please respond
to ORACLE-L
Babette,
The decision really comes down to the organization. If they see themselves
as *never* leaving the Cobol arena, and they have an ample supply of Cobol
programmers, then they should stay with it.
What you could do is to make friends with the applications people, and show
them how PL/SQL works. What you will find is that they will take to PL/SQL
like a fish to water. And pretty soon, more and more PL/SQL packages will
be written that are simply called by the Cobol programs. Cobol would then
be a simple entry point to the database - able to interface nicely with the
operating system (reading and writing flat files, producing reports and
forms), while the majority of the logic may be written in PL/SQL.
Maybe, just maybe, the person making the decision see's no benefit to using
PL/SQL. And given your local labor market, maybe he's right!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Sunday, November 17, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
"Khedr, Waleed" wrote:
>
> Cobol! Again!:(
>
> -----Original Message-----
> Sent: Friday, November 15, 2002 5:24 PM
> To: Multiple recipients of list ORACLE-L
>
> I just found out today that we have a major development initiative that
is
> starting and they are planning on using Pro*Cobol to develop the
> application. (my head is still shaking in disbelief!!!)
>
> So we will have a Java front-end, invoking MQ series that will go across
to
> the mainframe for MQ series to invoke Pro*Cobol programs that will then
do
> the processing (accessing data and doing calculations) and then return
data.
>
> If anyone has been in this or a similar situation, please help.
> I need some really good arguments as to why we should put the business
logic
> into PL/SQL instead of Pro*Cobol.
>
> I understand the reason we are using Oracle is that the director has 15
> years experience with it and loves it. Aaargh!!!
>
> thanks
> Babette
>
May I play the devil's advocate? Even if Pro*Cobol seems to be a weird
choice, there may be a case for not coding the logic in PL/SQL :
database portability. I have heard recently of a very, very, very big
company dumping Oracle in favour of DB2. Reason ? Cost. I guess that in
such a case, porting a Pro*Cobol program is easier than PL/SQL.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
