Skip to Main Content
Forums

ODP.NET

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!

Using sysdate as a parameter when calling procedure

660148Sep 16 2008 — edited Sep 17 2008
Is it possible to use sysdate as a parameter when calling a procedure in an OracleCommand?

As in:

Dim cnX As OracleConnection
cnX = New OracleConnection(connectionString)
Dim cmX As OracleCommand
cmX = New OracleCommand("{call dev.myproc(000, 'P1', (select to_char(sysdate-1, 'mm/dd/yyyy hh24mi') from dual), ?)}", cnX)

Thanks &
Cheers.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 15 2008
Added on Sep 16 2008
#odp-net, #parameter, #procedure
1 comment
2,545 views