Use show errors package in sqlplus to check the error

Show errors also works for procedure etc

You would also need to reference the package in your insert i.e. package_name.object_name - the...