From MsAccess to Oracle

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: Roland.Skoldblom_at_ica.se

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: ListGuru_at_fatcity.com (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).