You are viewing limited content. For full access, please sign in.

Question

Question

How to get data from Oracle datasource?

asked on October 20, 2022 Show version history

We are currently using MSSQL data sources for our lookup rules on Forms. Specifically stored procedures and sometimes tables (not views).

They are used when wanting to see specific data relating to a user.

We want to do the same with an Oracle database.

I was reading the documentation on https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/Settings/ODBC-Data-Sources.htm?TocPath=Forms%257CAdministering%2520Laserfiche%2520Forms%257CGiving%2520Processes%2520in%2520Laserfiche%2520Forms%2520Access%2520to%2520an%2520External%2520Database%257C_____1

and saw: "Forms does not support Oracle Stored Procedures."

So, is it possible to look up specific data using the Oracle connection? I am no DBA/sys admin and was wondering how you all might be doing it.

Laserfiche Forms Professional Version 10.4.5.324

0 0

Replies

replied on October 20, 2022 Show version history

Maybe you could link your SQL Server to the Oracle server and write a SQL stored procedure as a workaround. You can lookup data from oracle views and tables, just can't call Oracle Procedures.

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.