ODBC - StoredProcedure call

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

ODBC - StoredProcedure call

Bojan Fabijan
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


Reply | Threaded
Open this post in threaded view
|

Re: ODBC - StoredProcedure call

Ronald Hallam
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]>...

>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
>