Link to home
Start Free TrialLog in
Avatar of ASPDEV
ASPDEV

asked on

Pass Null value for Number field in PL/SQL from C#

Hello Experts,

I have a issue while inserting null into oracle database from .NET application. I have a field Phone  which is number in database, but want to insert null  when it's passed as parameter value and from application I also need to format the data(string value) and remove any symbols and insert just number.

E.g. 123-456-7890 should be 1234567890
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ASPDEV
ASPDEV

ASKER

Thanks, it works.