Kbase P134669: Is it possible to call Oracle stored procedure from Progress ABL session?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/8/2008 |
|
Status: Unverified
GOAL:
Is it possible to call Oracle stored procedure from Progress ABL session?
GOAL:
Is it possible to execute Oracle stored procedure from Progress ABL session?
FACT(s) (Environment):
All Supported Operating Systems
Oracle DataServer
FIX:
There are two ways to call Oracle stored procedures from ABL:
1. Use oracle data server. Pull the tables and stored procedures into schema holder, use 4GL run stored proc statement to call the stored procedure and read proc-text-buffer and handle results.
This approach requires Oracle data server license
2. If Oracle stored procedure can be called from command line, 4GL command os-command can be used to execute Oracle stored procedure.