Pass Through Query through Access

From: Guntram Ulrich <ulrich_at_vivai.com>
Date: Wed, 5 Sep 2001 15:04:09 +0200
Message-ID: <3b9622fc_1@news.arcor-ip.de>

Hi there,

I have the following PL SQL running on SQL Plus from Oracle:

declare

v_rc varchar2(300):='0';
v_text varchar2(30000);
v_xml varchar(30000):='<?xml version ="1.0"

standalone="no"?><!-- externe DTD einbinden --><!DOCTYPE BusinessRequest SYSTEM
"AdezWetosBsiReq.dtd"><BusinessRequest
TransactionId="1"><MSISDN>4915112600028</MSISDN><ChangeProduct><OldProduct>< Ser
viceLevel>56</ServiceLevel></OldProduct><NewProduct><ServiceLevel>43</Servic eLe
vel></NewProduct></ChangeProduct></BusinessRequest>'; v_oid number(30):=0819;
begin
adb_access.adb$fu_put_request(0819,'4915112600028',v_xml,:rc,:text); end;

Can anybody tell how I have to write it in an Access Pass Through Query to let it run successfully?

Thanks,

Guntram Received on Wed Sep 05 2001 - 08:04:09 CDT