Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OCIDescribeAny for column info ?

OCIDescribeAny for column info ?

From: Mart Käsper <mart_at_netsoftlund.se>
Date: Mon, 10 May 1999 16:41:23 +0200
Message-ID: <3736F013.C97C46E3@netsoftlund.se>


Hi,

I'm trying to use OCIDescribeAny() to find out column names and data types
for a specific table. The problem is that a segmentation fault occurs ...

  text objptr[] = "my_table_name";
  ub4 objp_len = strlen( (char*) objptr);

  OCIDescribeAny( servicehp, errorhp, objptr, objp_len, OCI_OTYPE_NAME, 1,

     OCI_PTYPE_TABLE, descrhp);

(all the handles above (servicehp, errorhp, descrhp) are allocated))

If I replace OCI_PTYPE_TABLE against ..._TYPE the program does not crash but it's a table I'm interested in ...

BTW - are there any other ways to specify a table apart from using its name ? What is a TDO ?

Thanks in advance !




   Mart Käsper                 E-mail : mart_at_netsoftlund.se
   Netsoft Lund                Tel    : TBD


==========================
==========================
====================

#include <std.disclaimer>


   Don't believe anything you hear or anything you say

Received on Mon May 10 1999 - 09:41:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US