Solved

Calling stored Oracle function in PowerBuilder

Posted on 2003-11-14
4
2,466 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
passing a variable to eclipse to debug 2 66
Insert several multiple frames into a single mainframe 3 57
How search webpage "viewable text" only 1 63
Angular JS Route 3 54
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…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

864 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now