ODBC - StoredProcedure call

Hi !

I have one simple question for one, who ever did it.
I just need to call stored procedure (MS SQL server or ORACLE) with
input and output parameters.
I have no problems with normal ODBC syntax (CREATE TABLE, SELECT, INSERT
.....)

Thanx in advance
    Bojan

Bojan,
    you can either use:

      DBConnection query: 'exec AAA q,r,s' or DBConnection exec: ''exec AAA
q,r,s' , where AAA is the named of the stored procedure and q,r,s are
parameters being passed into the stored procedure.

    There is a problem though if the stored procedure is going to return
rowcounts from more than one select or other operation, you will get an
error giving error number 16973: Cannot open a stored procedure with more
than one select statement ..'.   This according to MicroSoft knowledge base
can be cured by using a DSNless connection.


    Ron


Bojan Fabijan wrote in message <[hidden email]>...