Home -> Usenet -> comp.databases.oracle -> Inserting values into DATE datatype using OCI

Inserting values into DATE datatype using OCI

From: Puru Balakrishnan <pbalakrishnan_at_symantec.com>
Date: 1996/11/12
Message-ID: <328917A6.68F5_at_symantec.com>#1/1 







Hello,



I am having problems while inserting data into date datatype using OCI. 
The sequence of steps are:



    
  
  1.   SQL Statement:
	insert into datetime_table( intfld, datefld) values (?,?)

  
  2.   parse the SQL Statement by using oparse()

  
  3.   Bind placeholders using obndrv() function
	The values supplied to the program variable are:
	For integer field	- 999
	For date field		- TO_DATE('11-12-1996','MM-DD-YYYY')
   The datatypes for both of the above variables is set to VARCHAR2

  
  4.   Execute the SQL Statement using oexec() function






After (d), Oracle displays an error message "ORA-1858, a non-numeric 
character found where a digit was expected". 



I would like to know if this is the correct way to insert values into a
date


datatype or is there a better way to do this.



Thanks for any help/suggestions.



Puru Balakrishnan


Symantec Corporation
Received on Tue Nov 12 1996 - 00:00:00 CET












Original text of this message