Solved

Calling stored Oracle function in PowerBuilder

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

773 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