WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Latest posts > General

General

Hello,

We have set a working Oracle connection. There is a procedure with 2 params, one IN, another OUT. Running a Business Rule containing a SQL Command against the Oracle connection:

declare
l_out NUMBER;
begin
ZZ_WEBCON_TEST.TEST_PROCEDURE(P_IN => {BRP:21}, X_OUT => l_out);
end;

where {BRP:21} is a Business Rule decimal parameter.
The Rule is working, Oracle procedure gets executed (witness on Oracle db) and most probably returns l_out.

My question is: how do I get the l_out value? Tried another Rule parameter but query not working any longer.

Thank you,
Mihail

MVP

Hi,
I hadn't realized that.
I think you can set the edit mode option on the main form with default view.
You can replace the save button with a path.
You can hide the save button and create a path to the same step.
If the edit mode at the step is default view, it will no longer remain in edit mode.
Do you need to write or move that instance?
How does it affect you that they remain in edit mode?
Are there multiple people assigned at that step?

Thanks,
Raluca

MVP

Hi,
This approach is not recommended. Additionally,
the attached data is stored in the [dbo].[WFAttachmentFiles] table within the attachment database linked to the process.
If you occasionally need to restore a deleted attachment, it's advisable to download its latest version from the history in administrative mode and re-add it 'normally'.
However, if this situation occurs frequently, I strongly advise reassessing your process and finding an alternative solution to meet this requirement.
e.g. using API

Regards.

In reply to: Dariusz Tułacz

Adding a mass notification schedule resolved the issue. However, I don't understand why it was required?

MassNotificationSchedules  (for db: BPS_Content )

Hi Darek,
I would check two things. But not sure if this will answer your question. :)

1. Firewall - if port 8002 is enabled. It is responsible for portal - service connection (details: https://community.webcon.com/posts/post/configuring-portal-service-communication-and-selecting-nettcp-protocol/335/3).
2. Check settings of mass notification (attached file for guidance).

Best.