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!

Indicator variable doesn't work with functions

626351Mar 16 2009 — edited Mar 17 2009

I can't get an indicator variable to work along with the "to_date" function when trying to insert into an Oracle table from a 'C' program. I am not always guaranteed to have a non-null date value when inserting into the table. Any ideas ?

EXEC SQL insert into table values (to_date(:local_date, 'yyyy-mm-dd') indicator :my_indicator, ......)

thanks,
Vicki

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2009

Added on Mar 16 2009

12 comments

621 views