 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Fetch Out Parameter in Maintain Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Fetch Out Parameter in Maintain | Login/Join |
| Gold member |
Hi, I have a maintain screen which calls a Webfocus procedure which in turns calls an oracle stored procedure. I want to know how can we capture the OUT parameter from the stored procedure in Maintain. Basically I want to show the success/failure message to the user based on the OUT parameter's value. Thanks!This message has been edited. Last edited by: Kerry, Webfocus 7.7.03 Windows XP Excel, PDF, HTML, APDF, AHTML, Maintain | ||
|
| Guru |
exec fex from var into stackname; In the fex you call the stored procedure which returns a value in the OUT variable. The fex returns that value into stackname, where you can test on the value. Also, if you can code it directly in Maintain, there's a Maintain variable, called SYS_NGR.DBMS_ERRORCODE. Håkan WebFOCUS DS 8.0.06/08 DS/AS WebFOCUS RS 8.0.08 (Linux/IBM i) WebFOCUS Client 8.0.06 (Linux) | |||
|
| Expert |
From memory you can also get the messages from the WebFOCUS Proc, a msg stack i think. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
In addition to what was suggested you can also look at FOCMSG.MSG This is a default stack that passes back everything that was echoed to the screen. You can display it in an HTMLTable or use SUBSTR to parse any values that you need from it. You don't have to compute or infer this stack. You don't have to pass or receive it. It is automatic. Mark | |||
|
| Expert |
Thanks Mark for adding clarity my fading memory. Perhaps it should have been Claret...  Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Thanks Mark. It worked well for me! Webfocus 7.7.03 Windows XP Excel, PDF, HTML, APDF, AHTML, Maintain | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Fetch Out Parameter in Maintain | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |