We have some functions coded in Oracle packages that we would like to call from Pro-IV. I am the Oracle guy, so I have no clue how to have these called from Pro-IV.
In Oracle it would just be as simple as
select key_columns, package_name.func_name( column_args )
from table
where limit_field = some_value
Is there a way to code this in Pro-IV and have the same / expected results?
Any help is appreciated.
Thanks,
Layne
(Pro-IV version 4.1 build 119 if the answer is version specific.)
Click the link below to see the new game I'm developing!
Oracle packaged functions.
Started by
Guest_Layne Robinson_*
, Sep 28 1999 09:10 PM
1 reply to this topic
#2
Dan Shannon
-
- Members
-
- 374 posts
ProIV Guru
- Gender:Male
- Location:Australia
Posted 28 September 1999 - 09:48 PM
You should be able to use any SQL statement directly in PRO-IV by encoding it in a block of logic like so:
SQL
select key_columns, package_name.func_name( column_args )
from table
where limit_field = some_value
ENDSQL
PRO-IV will do the select into a table and you'd need to have a PRO-IV file def equipped to interpret the resulting columns and data types that are returned by the SELECT statement.
SQL
select key_columns, package_name.func_name( column_args )
from table
where limit_field = some_value
ENDSQL
PRO-IV will do the select into a table and you'd need to have a PRO-IV file def equipped to interpret the resulting columns and data types that are returned by the SELECT statement.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
