SEO

#1 (**permalink**) 04-09-2008, 11:27 PM

Hi noboday out there ??

Hi everybody

i would like to excecute a stored procedure in Oracle
from a Progress (Version 8.x) 4GL program like:

Example:

BEGIN
Dbms_Application_Info.Set_Module(module_name => 'add_order',
action_name => 'insert into orders');

-- Do insert into ORDERS table.
END;

Is is possible in Progress 4GL?
And how would it be coded (run stored-proce.....???)

thx,
Fritz

#2 (**permalink**) 04-09-2008, 11:27 PM

Fritz Bonhagen <fbonhage@yahoo.com> wrote in
news:3F350E5D.5010802@yahoo.com:

> Hi noboday out there ??
>
>
>
>
> Hi everybody
>
> i would like to excecute a stored procedure in Oracle
> from a Progress (Version 8.x) 4GL program like:
>
> Example:
>
> BEGIN
> Dbms_Application_Info.Set_Module(module_name => 'add_order',
> action_name => 'insert into
> orders');
>
> -- Do insert into ORDERS table.
> END;
>
> Is is possible in Progress 4GL?
> And how would it be coded (run stored-proce.....???)
>
>
> thx,
> Fritz
>
>

Look in the Oracle DataServer guide.. The syntax is something like:
RUN-STORED-POCEDURE(...) with the name of the stored proc in the
parenthesis.. www.progress.com/v9/documentation will show the proper
syntax.. Even though it is V9, the syntax for such things does not change
between versions..

Kevin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Progress + Oracle stored procedures