Procedure Columns using ODBC

From: ShivKumar <vihs_at_rocketmail.com>
Date: 1998/01/26
Message-ID: <885878418.707526658@dejanews.com>#1/1

Hi all,

When I use SQLProcedureColumns() to retrieve procedure information, it returns me SQL_NO_DATA_FOUND.

I use like this ..
SQLProcedureColumns(

  hstmt, // statement handle
  NULL,  // procedure qualifier name
  0,     // length of procedure qualifier
  NULL,  // procedure owner search pattern
  0,     // length of pattern
  procName, // procedure search pattern
  SQL_NTS,  // length of proc search pattern
  NULL,     // column name search pattern
  0,        // length of pattern

);

I Bind all cols and call SQLFetch(), it returns SQL_NO_DATA_FOUND.

It works with MS ODBC Driver for MS SQL Server. But fails for Oracle. I used Oracle7 ODBC Driver and Intersolv ODBC Driver.

Thanx for any help.

--

shiv
vihs_at_rocketmail.com

-------------------==== Posted via Deja News ====-----------------------

http://www.dejanews.com/ Search, Read, Post to Usenet Received on Mon Jan 26 1998 - 00:00:00 CST