Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Calling stored Oracle function in PowerBuilder

Posted on 2003-11-14
4
2,551 Views
Last Modified: 2013-12-26
How do I call a PL/SQL function stored in Orcale using PowerBuilder.
0
Comment
Question by:sudeepkukreti
4 Comments
 
LVL 8

Accepted Solution

by:
Vikas_Dixit earned 250 total points
ID: 9754201
There are diffrent ways...

Create a custom Transaction object,  declare your oracle function as a local external function on the transaction object.  Use your customr transaction object in the application. and call the oracle function just like any other external function :

SQLCA.fn_yr_oracle_funct(.....)

Or you can use the Declare procedure syntax::

DECLARE oracle_func PROCEDURE FOR
      fn_ur_oracle_func(:arg1, :arg2..., :ret_val);
EXECUTE oracle_func;

FETCH oracle_func INTO :out_var;


sEE FOLLOWING Q :
http://www.experts-exchange.com/Programming/Programming_Languages/PowerBuilder/Q_20784564.html

rEGARDS,
ViKAS d


0
 
LVL 8

Expert Comment

by:gajender_99
ID: 9762489
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand columnThat will then direct you to their download page.From that page s…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question