Re: Progress 4GL running Oracle stored procedure??

Hi Fritz,

I've migrated an app from Progress to Oracle 9i and I can tell you that the Dataserver isn't specifically about stored procedures. It's more about migrating a Progress schema to an Oracle schema and sending the Progress client's requests & instructions to the database via the OCI.

Having said that, what you want to do *is* possible! The Progress 4GL has a "RUN STORED-PROCEDURE" command that allows you to execute an Oracle stored procedure via the Dataserver:

RUN STORED-PROCEDURE procedure

  [ integer-field = PROC-HANDLE ]
  [ NO-ERROR ]
  [ ( parameter [ , parameter ] ... ) ]

I'd recommend the online documentation for the Dataserver at www.progress.com, and the Progress e-mail group's servers mailing list (servers_at_peg.com), where Dataserver issues are discussed.

HTH
Nick

"Friedrich W. Bonhagen" <fbonhagen_at_onlinehome.de> wrote in message news:3F35122E.9020404_at_onlinehome.de...
> Hi everybody
>
> i would like to execute a stored procedure in Oracle
> from a Progress (Version 8.x) 4GL program.
>
> For example:
>
> BEGIN
> Dbms_Application_Info.Set_Module(module_name => 'add_order',
> action_name => 'insert into
orders');
>
> END;
>
> Is is possible in Progress 4GL?
> I think Progress has an Oracle Data Server (gateway) that could work.
> How would it be done?
>
>
> thx,
> Fritz
>
Received on Mon Aug 11 2003 - 03:28:25 CDT