Running an Oracle Stored Procedure from a Webapp Button

Answered

Michael Foxall

• July 23, 2019 07:56

We have several Automate processes that Execute Oracle procs on schedule. There are set up with a hidden webapp page with a button on that calls an automation engine instruction which fires off the Oracle Proc.

The Webapp button errors when clicked directly, only when executed via Automate, passing a value for the instruction will it work.

This has been fine so far, but now i am being requested to add a button directly to several of the pages in one of out webapps that the user can process the data they have added by running a proc.

When i set the same settings to the button as Automate, i get the message below.

I am unsure why it is returning multiple records or how to resolve this.

 

Thanks in Advance.

 

WebApp Design or Configuration Error

The current WebApp appears to have a design or configuration error.

Description

Public WebApp Event must not return more than one row.

An error has occurred. Please contact your technical support for assistance. When submitting an issue please expand the subsections by pressing the show buttons and selecting and copying the entire page into a file to attach to the issue or any email correspondence. Additionally, please attach any relevant screen shots, a description of what you were trying to do, and a description of what you expected to happen.

 

Show

General Information

The table below includes general information about the website.

Request Information
WebApp	PlacesForPeople
Page	Corporate Dashboard Detail
Event	< Deprecated >
System Information
CranSoft Website	Default Web Site
CranSoft Version	7.0.4.127 ()
WebApp Version
UserID	mfoxall
User Information
Language	English
LanguageID	b16ea10f-7d20-4851-b941-d84252632951
LocaleID	2048

Show

Additional Information

The table below contains additional information that was reported by the website.

Calling PageID	032a1363-67c0-459b-927a-4680dade5b89
Calling Event	SendToTarget
WebApp Event PageID	51ff7719-4be8-419a-873b-f37f70478134
WebApp Event	PushCorpDashToTarget
Record Count	2

Show

Keywords

WebAppEvent_BadTarget, WebAppEvent, Target, Records

1

• Best answer

  

  Ben Bauer

  • July 23, 2019 16:09

  Hi Mick,

   

  When calling a Public WebApp Event, it is necessary to specify at least the "Key" parameters that are registered to the event.

  • In Automate, specifying the parameters is very straightforward and that seems to be working just fine for you.
  • However, in a page's button event, specifying the parameters is not an intuitive process.  This article in the Online Help describes the process: https://dsphelp.syniti.com/706/general/WebApp_Dev/SetParameterValueBusinessRules.htm

   

  But even that Online Help article fails to mention the *Evt view that must first be registered as the [Parameter View] of the Business Rule.  This is the old column description (which is accurate):

  "Parameter View

  The View that will provide the Parameter values for the WebApp Event to be called by this Business Rule when it executes. When constrained by the primary keys of the record for which this Business Rule is running, the Event Parameter View must return exactly one record."

  This is where you find the column:

  

   

  After the [Parameter View] is set, then the instructions in the Online Help are accurate.  You click into 'Parameters' and map the columns from your *Evt view.  By the way, *Evt means the view needs to be named like webPageTableEvt.  However, as the old column description notes, it is very important that the *Evt view contain the same records as the *Hor view.  I often just copy the *Hor view and then save it as *Evt.

   

  For additional assistance, I recommend we move this to a Support ticket.  Just let me know and I can make that happen.

   

  Thanks,

  Ben

  1
• 

  Michael Foxall

  • August 19, 2019 13:39

  Hi Ben.

  Thanks for this,

  I haven't yet managed to achieve this, however a DSP contractor (Karl Boseley) is very kindly helping me with this following your advise, although as i am juggling several projects I've not yet been able to dedicate enough time to get this completed.. 

  I will let you know if i require assistance in moving this to a support ticket. I just felt you deserved a response.

   

  Thank you.

   

  Mick Foxall

  1

Please sign in to leave a comment.