Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Oracle stored Procedures

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Oracle stored Procedures
 Login/Join
 
Veena
Member
posted
I need a solution of calling an oracle stored procedure with 2 input parameters and two output parameters in webfocus

This message has been edited. Last edited by: <Kathryn Henning>,
 
Posts: 1 | Registered: December 07, 2011Report This Post
Clif
Guru
posted Hide Post
Create a synonym for the stored procedure. Then you can write a TABLE request against the synonym, pass input parameters in IF tests and get the output parameters back as an answer set.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
Shankar
Guru
posted Hide Post
Hi,
Sorry to restart this topic. I also have same requirement with two input parameters(datatypes CHARACTER and DATETIME) and one output parameters. But when i create synonym for Stored proc, It is prompting for Input variables values. What values am i supposed to pass as these value will be dynamic and will come at runtime.
Is it some sort of default value? Then what value need to be passed for DATETIME input parameter?
Please help me get it sorted with example or any reference if possible.

Thanks in advance.


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
 
Posts: 281 | Location: India | Registered: April 21, 2007Report This Post
<Kathryn Henning>
posted
Hi Shankar,

The following document may address your questions:

Synonym for Oracle Stored Proc. does not reflect output parm
https://techsupport.informatio...om/sps/60702541.html

As always, you may contact Information Builders’ Customer Support Services for assistance at any time. The phone number is 1-800-736-6130, or you may access the online system at InfoResponse. Here is a list of information to have ready when you call: Before You Call InfoResponse Support

Hope this helps.

Regards,

Kathryn
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Oracle stored Procedures

Copyright © 1996-2020 Information Builders