'OCIDateToText' : function does not take 8 parameters

'OCIDateToText' : function does not take 8 parameters

Post by li.. » Sat, 02 Sep 2000 02:45:01


I am using OCI(version 8.1.5) data conversion function OCIDateToText as

void ShowBind(OCIError * errhp)
        int size;
        text * buf;
        switch (Bind.type)
        case SQLT_DAT:
                OCIDateToText(errhp, Bind.col, DATE_FMT, DATE_FMT_LEN,
     (CONST text *)NULL, 0, (ub4 *)&size, (text *)buf);

Bind.col is the OCIDate structure. I got

error C2660: 'OCIDateToText' : function does not take 8 parameters

in compiling. I just wonder if there is any inconsistency between the
documents and the function definition.

I also look at OCIDateToText definition in orl.h and it is:

sword OCIDateToText(    OCIError *err, CONST OCIDate *date,
                        CONST text *fmt, ub1 fmt_length,
                        CONST text *lang_name, ub4 lang_length,
                        ub4 *buf_size, text *buf    );

I do not know if Oracle changed the definition without modifying this
header file. I also want to know if you had this problem in OCI V 7X or



Sent via Deja.com http://www.deja.com/
Before you buy.


1. user-defined functions that return a table can't takes getdate() as parameters


I have just come across a problem that I can't feed getdate
() to functions that return a table while feeding constant
values like '1/1/01' is allowed. Anybody has comments?
Functions returning a scalar value seem to be fine.

returns table
/* select statement here*/

calling the function
select * from dbo.dum(getdate())

error message:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '('.

whereas feeding constant is fine
select * from dbo.dum(getdate())

2. 6.5 problem

3. It's not ODBC - It's not ASP - It's OLE/DB

4. Using iigenres to set new locking parameters in OI

5. BCP takes lot's of memory and doesn't release it

6. Lost someone, can I access large DB to find?

7. ADO thinks DBMS is done, but DBMS ain't done

8. Two optional parameters in where clause

9. Inordinate growth in DB when doing backup's and restore's

10. doing 'read-only' querys

11. function's parameters

12. How set parameters for 'Select * from Suppliers where SuppID in ('111', '222', '333')'

13. **************!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Help me !!!!!!!!!!!!!!!!!!!!!!!!'''''''''''''''''''''''*************