cazzafed
Active Member
Hello all,
can execute SQL update/delete/select from enterprise one application?
I'm using 9.2
Best regards.
can execute SQL update/delete/select from enterprise one application?
I'm using 9.2
Best regards.
Scott Beebe
Reputable Poster
You will need to build a C function and use the JDB_* API calls to build and execute the SQL statement.
BOster
Legendary Poster
To expand on Scott's answer. The JDBBASE APIs that Scott is referring to give you a LOT more tools at your disposal (as opposed to ER only) to construct some very complex SQL that you simply cannot do in ER code alone.
However, to strictly answer your question, when you do ER code F0101.Select, F0101.Update F0101.Insert, etc. or use data bound controls in a form (like a grid tied to a business view) you are "execute SQL update/delete/select from enterprise one application", so you may want to be a little more specific on what you are trying to accomplish.
However, to strictly answer your question, when you do ER code F0101.Select, F0101.Update F0101.Insert, etc. or use data bound controls in a form (like a grid tied to a business view) you are "execute SQL update/delete/select from enterprise one application", so you may want to be a little more specific on what you are trying to accomplish.
wadedaw1
Member
Create a form with a data fields and button that upon press inserts to a custom table. Put a database insert trigger on that table that executes an SQL. You can structure the table to store data useful to the trigger's SQL.
JohnDanter2
VIP Member
If you mean an SQL totally independant of your applications screens functions, yes.
If you are on 9.2, you have access to Orchestrations right?
You can save the SQL as a stored procedure maybe and then call it in groovy as shown in here
If you are on 9.2, you have access to Orchestrations right?
You can save the SQL as a stored procedure maybe and then call it in groovy as shown in here
E1: ORCH: How To Call SQL Oracle Stored Procedure From Groovy Using Orchestrator
JD Edwards EnterpriseOne Orchestrator - Version 9.2 and later: E1: ORCH: How To Call SQL Oracle Stored Procedure From Groovy Using Orchestrator
support.oracle.com
