Solved

Calling stored Oracle function in PowerBuilder

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

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: …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

726 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