DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to pass bind variable via ODBC?

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    We are using a VB application and we want to use bind variables in our procedures. How do we pass these bind variables via ODBC?

    e.g.
    PROCEDURE GetPax (strDate IN VARCHAR2, strArrDep IN VARCHAR2, strDomInt IN VARCHAR2, strTermi IN VARCHAR2,
    ) IS
    ....
    sslectstmt = 'select * from table_name where code ='''||strArrDep||'''';

    Thanks.

  2. #2
    Join Date
    Jun 2002
    Location
    Denver
    Posts
    54
    You need to look for VB documentation for that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width