Skip to main content

How I Can Learn To Write Procedures?

  • July 18, 2020
  • 3 replies
  • 194 views

0guz
Hero (Employee)
Forum|alt.badge.img+10

Hello,

I want to learn writes procedures on IFS database as i said. So is there any document for explaining API’s buildings, procedures etc.

Can u show me good way for my wish.

Kind Regards.

3 replies

durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • July 19, 2020

There are examples here if I remember correctly. (This page is restricted to authorized users.) https://community.ifs.com/technology-97/is-there-a-way-to-call-a-custom-api-378


0guz
Hero (Employee)
Forum|alt.badge.img+10
  • Author
  • Hero (Employee)
  • July 19, 2020

Hello @durette thank you again :grinning:

Yes i cant view that page. So What i should do for being an authorized user?


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • July 20, 2020

Here’s an example of Oracle PL/SQL in action. This creates a custom package, adds it to the dictionary cache, grants it to a permission set, refreshes the security cache, creates a database task, and sets up a database task schedule.