Forum OpenACS Development: issue during package installation

When i am installing forums package, i am receiving this error. I had set the date format and encoding as below in the bash_profile.

export NLS_DATE_FORMAT="YYYY-MM-DD"
export NLS_LANG=.UTF8

nsoracle.c:3542:ora_tcl_command: error in `OCIStmtExecute ()': ORA-01861: literal does not match format string
ORA-06512: at line 4

SQL:

begin
:1 := apm_package_version.new(
version_id => :version_id,
package_key => :package_key,
version_name => :version_name,
version_uri => :version_uri,
summary => :summary,
description_format => :description_format,
description => :description,
release_date => :release_date,
vendor => :vendor,
vendor_uri => :vendor_uri,
auto_mount => :auto_mount,
installed_p => 't',
data_model_loaded_p => 't'
);
end;

The server is running properly without any problem. But it is not allowing me to install any of the packages. For every install, i am getting the same error. Can anyone help me out with this.

Thanks

Both the things you specified are in the right places. But still i am getting the same error. Anything else could be the reason?

Thanks,
Asif.

The environment variable are set in 2 places. one in my bash profile and another in the run file of aolserver. In run file the format is different hence it is giving the error.

It is fixed now. Thanks a lot for the help.

Asif.