Error Message when i try to excute the procedure by passing some input parameter

[praveena]

Hi ,

Thanks for your help.I found the error,It is not becuase of the Column .The way i executed the procedure was wrong.When I uesd the following statement it worked fine.

exec tpp_locations_ins ( '2', '2', '17', 'test1', '1', 'e', 'a', sysdate, 'a', sysdate, 'd', NULL, NULL, NULL, NULL, nULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, nULL, nULL, NULL,'tzone000000000000002', NULL, NULL, NULL, NULL, NULL, '2') ;

Regards,
Praveena