Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while connecting to workflow builder after installation...first time!

650593Jan 2 2009 — edited Jan 2 2009
Hi,

I have installed Oracle Workflow Builder 2.6.3 recently on my system and after installation, when I am trying to connect the workflow builder (using database username/password of that particular instance), it is throwing me the following error:

220: Unable to set NLS_LANGUAGE.
210: Oracle Error: ORA-01403: no data found
. SQL text: SELECT NLS_LANGUAGE FROM WF_LANGUAGES WHERE :l IN (NLS_LANGUAGE, CODE)

In the previous threads when I searched for the same issue, I found that if
select value from v$nls_parameters
where parameter='NLS_CHARACTERSET';
returns the value other then WE8ISO8859P1 then that is what I should change my NLS_LANG entry for the builder - i.e. AMERICAN_AMERICA.<character set>.

But I am not getting where should I change NLS_LANG, it is located where...some file? I am new to Workflow.
Please help me. I tried a lot. Any type of help will be highly appreciated.

Thanks,
Sumir
This post has been answered by OrionNet on Jan 2 2009
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 30 2009
Added on Jan 2 2009
2 comments
6,550 views