| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
<NDATFM_at_labor.st <ORACLE-L_at_fatcity.com>
ate.ny.us> cc:
Sent by: Subject: RE: New development in Cobol or PL/SQL - please
root_at_fatcity.com 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: sfaroult_at_oriole.com 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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us 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: ListGuru_at_fatcity.com (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: Rick_Cale_at_teamhealth.com 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: ListGuru_at_fatcity.com (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).Received on Mon Nov 18 2002 - 08:19:18 CST
 |
 |