Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TO_DATE in Pro*C

3738106Nov 2 2018 — edited Nov 5 2018

Hi,

We have some embedded SQL code (C) that inserts into a table.  Some columns are dates and I need to know how to call TO_DATE

given that the column is nullable.

For example:

EXEC SQL INSERT INTO mytable VALUES (:var_date:null_1);

How can I convert this to use TO_DATE?

TIA

Comments
Post Details
Added on Nov 2 2018
25 comments
1,095 views