how to call procedure?

From: Sebastian Degenaar <degenaar_at_adlink.com.au>
Date: Fri, 15 Oct 1999 00:57:59 +1000
Message-ID: <3805EF77.6FCB539E@adlink.com.au>

How do I make a call to this procedure through ODBC. What is the syntax to call it:-

CREATE OR REPLACE PROCEDURE CSNTAUTHUSERPAP (CSNTUSERNAME in varchar2, CSNTPASSWORD in varchar, CSNTRESULT out INTEGER, CSNTGROUP out INTEGER, CSNTACCTINFO out varchar2, CSNTERRORSTRING out varchar2, CSNTPASS out varchar) AS
  syspassword VARCHAR2(30);
  sysusername VARCHAR2(30);
begin

   CSNTresult := 0;
   CSNTerrorstring := 'authentication successful';    CSNTacctinfo := '';
   CSNTpass := '';
   CSNTgroup := 0;
   begin

      select customer_n, anusername, anpassword, angroup
      into CSNTacctinfo,sysusername, CSNTpass, CSNTgroup  -- <--Must be
select .. into ... from .........
      from internet
      where anusername = csntusername
      and anpassword = csntpassword;
   exception
       when no_data_found then
          CSNTresult := 4;
          CSNTerrorstring := 'authentication failed';
       when others then
          CSNTresult := 5;
          CSNTerrorstring := 'some other errors';

   end;
   return;
end;

Thanks in advance Received on Thu Oct 14 1999 - 09:57:59 CDT