Naval

Thanks for your responses.

You were right i was passing a numeric value to date datatype. I have modified the code. Now it is working fine.

Also Richard i am getting value back into Proiv. Using bind variable(:#RESULT) it is possible.


SQL

BEGIN
:#RESULT := Nmis_Extract.load(TO_DATE(TRIM(:$START_DATE),'DD/MM/YYYY'),TO_DATE(TRIM (:$END_DATE),'DD/MM/YYYY'),:$$TRIG_FILE ,:$$TARGET_DIR) ;

END ;
ENDSQL

Cheers,
Naval

you are right problem was the case of the parameters.
Thanks tclulow

Regards,
Naval

Its working now.

Thanks Vol