Skip to main content
Question

Performing CRUD operations on virtual tables from packages other than plsvc

  • 20 November 2024
  • 0 replies
  • 31 views

Forum|alt.badge.img

Hi,

Is it acceptable to perform a CRUD operation in SQL on a virtual table from a function in the Entity or Utility package? (not PLSVC)
I think it is technically possible, but I‘m wondering if there is a problem with the above implementation since it is different from the original use of virtual tables.

 

As background to this question, we want to develop an add-on backgroundjob program that performs the same process as Register Arrivals.
We’re trying to develop using a IFS standard function that is called when the “Receive” button is pressed, but before calling this function, the data must be registered in some virtual table. (CREATE_RECEIPT_CREATE_RECEIPT_VIRTUAL_VRT, etc.).

Therefore, it is necessary to register data in the Virtual table in the add-on job program, which is why I asked this question.

Any other solutions to this are welcome.

 

Thank you,

Akane

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings