Use ADO.
-----Original Message-----
Sent: Friday, February 15, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L
Hallo,
Please tellme how to write the MsAccess procedure to call the pl/sql
procedure proc_konk, I am not using ADO in MsAccess
The pl(/sqlprocedure looks like this:
Procedure proc_konk
(v_butiks_nr in pbk.konkurrentbutik.BUTIKS_NR%type,
v_namn in pbk.konkurrentbutik.NAMN%type,
v_butiktyp in pbk.konkurrentbutik.BUTIKTYP%type,
v_region in pbk.konkurrentbutik.REGION%type,
v_postnr in pbk.konkurrentbutik.POSTNR%type,
v_postort in pbk.konkurrentbutik.POSTORT%type,
v_adress in pbk.konkurrentbutik.ADRESS%type) is
lvsql VARCHAR2(2800);
BEGIN
lvsql :=
'INSERT into PBK.KONKURRENTBUTIK (' ||
'butiks_nr,' ||
'namn,' ||
'butiktyp,' ||
'region,' ||
'postort,' ||
'postnr,' ||
'adress )' ||
'VALUES ('||
v_butiks_nr||','''||
v_namn||''', '||
v_butiktyp||',' ||
v_region||','''||
v_postort ||''',' ||
v_postnr ||',''' ||
v_adress ||''')';
DBMS_OUTPUT.PUT_LINE(lvsql);
EXECUTE IMMEDIATE lvSQL;
END PROC_KONK;
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
