Hi,
I use VB 4 (32 bits), DAO 3.0 and Oracle 7.3 WorkGroup NetWare.

How can i call a stored procedure

my procedure is

CREATE OR REPLACE PROCEDURE SQ_Ok AS
        maxi    NUMBER(6);
        id      NUMBER(6);
BEGIN
        SELECT max(id_type_support) INTO maxi FROM type_support;
        SELECT SQ_type_support.NEXTVAL INTO id FROM dual;
        WHILE id < maxi LOOP
          SELECT SQ_type_support.NEXTVAL INTO id FROM dual;
        END LOOP;
END;
/

PLEASE HELP ME.

--
Far Informatique
5,Rue de Conflans
94220 Charranton le Pont
FRANCE

Shalom,

My wishes are with you,

*str

Run-time error '3146':
ODBC-call failed

I tried "execute PACKAGE.PROSEDURE ()" as well as
"begin PACKAGE.PROSEDURE (); end" form.

Does anyone have a sample code using VB4(32bit) + ODBC(Oracle73)
using Pl/SQL stored procedures (or packages)?

Thanks,
Drasko
European Space Agency

  > >
  > > Shalom,
  > >
  > > >How can i call a stored procedure
  > >
  > > Take a look at the EXECUTE method of DAO or RDO.
  > >
  > > My wishes are with you,
  > >
  > > *str

  > Yeap, the EXECUTE method looks promising, but it doesn't work.
  > I get following:

  > Run-time error '3146':
  > ODBC-call failed

  > I tried "execute PACKAGE.PROSEDURE ()" as well as
  > "begin PACKAGE.PROSEDURE (); end" form.

  > Does anyone have a sample code using VB4(32bit) + ODBC(Oracle73)
  > using Pl/SQL stored procedures (or packages)?

  > Thanks,
  > Drasko
  > European Space Agency

Perhaps if you use Execute with the dbSqlPassthrough option?

--

WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!