[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Calling stored Oracle function in PowerBuilder

Posted on 2003-11-14
4
Medium Priority
?
2,879 Views
Last Modified: 2013-12-26
How do I call a PL/SQL function stored in Orcale using PowerBuilder.
0
Comment
Question by:sudeepkukreti
[X]
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
4 Comments
 
LVL 8

Accepted Solution

by:
Vikas_Dixit earned 1000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
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…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

656 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