473,756 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Get calling instance information in external procedure

Hi,

I have a question about how to retrieve the information of the calling
instance, such as instance name, in an external C procedure.

Thank you,

Carlo Chung
Jul 19 '05 #1
3 4352
ca********@hotm ail.com (Carlo Chung) wrote in message news:<5e******* *************** ****@posting.go ogle.com>...
Hi,

I have a question about how to retrieve the information of the calling
instance, such as instance name, in an external C procedure.

Thank you,

Carlo Chung


Why not just pass this information in?

-- Mark D Powell --
Jul 19 '05 #2
How? Thanks.

Carlo

Ma*********@eds .com (Mark D Powell) wrote in message news:<26******* *************** ****@posting.go ogle.com>...
ca********@hotm ail.com (Carlo Chung) wrote in message news:<5e******* *************** ****@posting.go ogle.com>...
Hi,

I have a question about how to retrieve the information of the calling
instance, such as instance name, in an external C procedure.

Thank you,

Carlo Chung


Why not just pass this information in?

-- Mark D Powell --

Jul 19 '05 #3
ca********@hotm ail.com (Carlo Chung) wrote in message news:<5e******* *************** ****@posting.go ogle.com>...
How? Thanks.

Carlo

Ma*********@eds .com (Mark D Powell) wrote in message news:<26******* *************** ****@posting.go ogle.com>...
ca********@hotm ail.com (Carlo Chung) wrote in message news:<5e******* *************** ****@posting.go ogle.com>...
Hi,

I have a question about how to retrieve the information of the calling
instance, such as instance name, in an external C procedure.

Thank you,

Carlo Chung


Why not just pass this information in?

-- Mark D Powell --


How? As part of the parameter list to the "external" procedure where
the external procedure in question is the official Oracle method for
linking external procedures to the database (version 8.1+). See the
DBA Administration and OraNet manuals.

HTH -- Mark D Powell --
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4943
by: Lisa Tang | last post by:
Hi, I am trying to call a C function from PL/SQL and I encounter "ORA-06525 Length Mismatch for CHAR or RAW data". Following is the information: C function in util.dll: INT Scramble(BYTE *input, BYTE *key, INT which,
4
4970
by: Sivakumar Shanmugam | last post by:
Group.. We are running on db2 UDF V8 on Sun solaris platform. I created an UDF which calles a C-routine(SQL_API_FN). This C-routine in turn calls an external C-function. The C-function is provided to us by a vendor(PCMILER application). The C-Function does the following operations- Open the server,get distance between two points and close the server. It takes two input parameters(points). Whenever I call UDF via select statement it always...
5
2567
by: claus.hirth | last post by:
If I create the function HELLO in schema S01 as follows, @ CREATE FUNCTION S01.HELLO() RETURNS VARCHAR(32) EXTERNAL NAME 'UDFSRVXYZ!sayHelloWorld' LANGUAGE JAVA PARAMETER STYLE DB2GENERAL NO SQL DETERMINISTIC
30
2287
by: Tim Marshall | last post by:
Here's the scenario, A2003, Jet back end, illustrated with some cut down code at the end of the post: A proc dims a snapshot recordset (dim rst as Dao.recordset) and opens it. There are several nested do loops, going through the records in rst using .movenext. At one point in one of the loops, we'll say the rst is at record "a". Now, another subprocedure is called, passing rst to it. In the subprocedure, the recordset goes through a...
0
1789
by: Michael | last post by:
Trying to call an external DLL (compiled within Fortran) and keep on getting the following error in the main call to the external DLL ' Object reference not set to instance of object' The DLL import definition is located within its own class as follows: ' ' Imports System.Runtime.InteropServices '
4
5327
by: Peter Piry | last post by:
hi, I've writte a DLL in VB.NET which is called from VB6. When I try to call some methods of the DLL in a sub Procedure I get the following error: "Object reference not set to an instance of an object." this is my code in VB6 (simplified)
1
2975
by: amgupta8 | last post by:
Note: This problem occurred when I updated the JDK from 1.3.1 to 1.4.1 or 1.4.2. Nothing else was changed in the code, other than updating the JDK on the database server (dbm cfg parm jdk_path) and recompiling/executing the code with 1.4.1 (deploying the newly compiled stored procedure code as well). This is the original exception that I got before I tried any code modifications: java.io.IOException: invalid offset/length at...
0
1416
by: aravindalapat | last post by:
Hi All, I am facing an error when I try to invoke a remote nested stored proc. Please find the details below. 1) SP TEST1 is defined in DB2 instance DB2A. It is calling a stored procedure REMOTE1 which is defined in another instance DB2B. 2) Before actually calling REMOTE1, the calling stored procedure is connecting to DB2B instance using connect statement and the remote storedprocedure is called with the name...
3
583
by: Carlo Chung | last post by:
Hi, I have a question about how to retrieve the information of the calling instance, such as instance name, in an external C procedure. Thank you, Carlo Chung
0
10014
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9844
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9819
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9689
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8688
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7226
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5119
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5289
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3326
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.