Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |