473,385 Members | 1,384 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

How to need to access the DB1 procedure through db link from DB2

[Split from old thread]

In DB1, i have a procedure which takes objects types
as parametres (input & output) like below
Expand|Select|Wrap|Line Numbers
  1. CREATE TYPE BCI.BCIWSR_ORD_ATTACH_REC_TYPE IS OBJECT
  2.    ( category_name                VARCHAR2(30),
  3.      orig_sys_document_ref        VARCHAR2(50),
  4.      orig_sys_line_ref            VARCHAR2(50),
  5.      note_description             VARCHAR2(200),
  6.      note_text                    VARCHAR2(5000),
  7.      url                          VARCHAR2(300),
  8.      attachment_id                NUMBER,
  9.      header_id                    NUMBER,
  10.      order_number                 NUMBER,
  11.      line_id                      NUMBER,
  12.      line_number                  NUMBER
  13.    )
From DB2 i need to access the DB1.procedure through db link.
Any other way to access the same in stead of pl/sql tables.

your help is highly appreciated.

Thanks
Samba
Oct 18 '10 #1
0 1109

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Colin Steadman | last post by:
I've written an online survey in ASP using Access as the db. To get the results and some data about the user I've written a simple select query in Access and saved it as 'QRY_GET_RESULTS'. ...
7
by: berkay | last post by:
i have a txt file; berkay#white jack#black smith#jane writes in it. and after i run the program it only prints smith jane and crashes what is wrong?
2
by: MLH | last post by:
I routinely save failure notices from mail servers bouncing mail back to me that I sent with invalid address. I would like to write an access procedure in my contacts database that would open the...
1
by: WillieW | last post by:
Hi folks, I have Access 97 and have set up four tables, each with a Primary Key with a file name manually entered. For example, the four tables relate to information stored in a paper file, on...
5
by: Craig | last post by:
Hi folks, I like the idea of being able to link an Access database to Microsoft Outlook, but I'm wondering: 1.) If I do this, what happens to the e-mail attachments (I'll bet they get dropped)?...
12
by: rdemyan via AccessMonster.com | last post by:
I'm having a complicated linking problem. Before I get into the particulars, I'd like to know how Access links to the back-end file at startup, AFTER I've distributed my application to the client....
0
by: jpezhil | last post by:
I Need Stored Procedure Example Program (Vb) Plz Send me (Insert,Delete,Update) Thanking U(For u'r Reply)
4
by: amanda27 | last post by:
I am creating a database where an excel spreadsheet will be imported and then different information will be taken from that spreadsheet to give different reports and graphs. I am having a problems...
4
by: =?Utf-8?B?TS4gV2lsc29u?= | last post by:
Hello, Can I run a procedure that resides in an Access database in VB.net? If yes, I would be ever so greatful if code was provided. Thanks, M. Wilson
76
by: JFKJr | last post by:
Hi, the following Excel VBA code is used to select 5 rows by double clicking the cell in the first column corresponding to that row. The code is working fine in excel. But, I need Access VBA code,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.