Oracle Forms

Check this threads and links will help you.

Rupee Symbol in Oracle Database

http://www.orafaq.com/forum/t/174635/

http://www.orafaq.com/forum/t/170826/

Thanks for your reply Kalpataru,

 Now I made it to work by just copy paste the ₹ (Rupee Symbol) from Microsoft word by character mapping and respective fonts installation. Have a look at the below screenshot of my application,

 What is my requirement now is if I hit shift+4 it inserts $ symbol and If I hit ctrl+shift+4 from my keyboard it should insert ₹ Rupees Symbol to Microsoft Word.

Do you have any suggestions to make this work.

Regards,

Soofi

Hi Soofi,

I think key press Ctrl+Shift+4 will not work on forms text item like you are doing in Microsoft Word.

select unistr('\20B9') rupee from dual
₹

You can do this store the rupee symbol in your table in the database and fetch from database to form's or module's text item.lselect unistr('\20B9') rupee from dual

Check this links http://stackoverflow.com/questions/18120723/how-to-insert-indian-rupee-symbol-in-oracle-11g and Rupee Symbol in Oracle Database

https://en.wikipedia.org/wiki/Indian_rupee_sign#Unicode

You can try this out by using java jar files.

In Oracle Reports you can do this i have already given the link check my previous post.

Do you want to show the symbol in a prompt? If so, i remember that i had a similar problem some years ago with the €-symbol.

My solution was to put a placeholder in the prompt and set the value at runtime in the WHEN-NEW-FORM-INSTANCE-trigger using the CHR(xxxx)-function, where xxxx is the character-code for your smybol.

No Andreas I need to insert ₹ or € symbol in oracle forms text item through a shortcut in keyboard (as like in Microsoft Word by pressing ctrl+shift+4 it will insert the symbol).

Is this possible in Oracle forms?

Regards,

Soofi

Have you tried which i have given in my previous post those thing are working or not ?

select unistr('\20B9') rupee from dual
₹

Hi

For forms try...

Number To Indian Rupee Words in Oracle Forms / Reports | Fox Infotech

For reports try many suggestions...

http://www.orafaq.com/forum/t/174635/

http://www.orafaq.com/forum/t/170826/0/

https://books.google.com.eg/books?id=j8OnBQAAQBAJ&pg=PA94&lpg=PA94&dq=oracle+form+%2B+Rupee&source=bl&ots=dBQNzhpld2&sig…

Amatu Allah.

@"Kalpataru" the select statement you provided works fine in my environment, but my requirement is to map the ₹ character in a shortcut key.

Your valuable suggestions greatly appreciated.

I have given you the query because it is very hard to go with the key Ctrl+Shift+4 and create ₹ symbol on text item.

So, you can use the above query and put ₹ in text item for that i have given you the above query.

But you can easily put ₹ in Oracle Reports, i have also given the link in my previous post.

You can try with java for putting (Ctrl+Shift+4) ₹ in forms text items.

Kalpataru wrote:

I have given you the query because it is very hard to go with the key Ctrl+Shift+4 and create ₹ symbol on text item.
So, you can use the above query and put ₹ in text item for that i have given you the above query.
But you can easily put ₹ in Oracle Reports, i have also given the link in my previous post.

You can try with java for putting (Ctrl+Shift+4) ₹ in forms text items.

Yes of course I already did that in Oracle reports and also in forms (text item) using a button, but my requirement is to do with a shortcut key. Will you provide me any outline to achieve this?

In general the keyboard should be transparent to the forms-application. So, if the keyboard is capable of producing the symbol, it should also the shwon in forms.

One way to insert the sign is using ALT followed by the ascci-code of the symbol.

What you could do is define a Key-mapping in the .res-file used by forms ( here a guide from 10G https://docs.oracle.com/cd/B14099_19/web.1012/b14032/configure011.htm, but it should also work in 11G or 12C).

Once you mapped a keyboard-shortcut zo a function (e.g. to the custom function F1), you can create the matching key-trigger (in this case KEY-F1) and insert you sign into the current field. Be aware that you can't insert the symbol at the current cursor-position in the current-field, but only append it either to the beginning or the end of the field.

If you want a more sophisticated version, you have to write a javabean as already suggested by @Kalpataru .

Andreas Weiden wrote:

In general the keyboard should be transparent to the forms-application. So, if the keyboard is capable of producing the symbol, it should also the shwon in forms.

One way to insert the sign is using ALT followed by the ascci-code of the symbol.

Is this possible to insert the sign in Oracle Forms Text field using ALT + ascii code?

Soofi wrote:

Is this possible to insert the sign in Oracle Forms Text field using ALT + ascii code?

For this you can try to do key mapping file which in fmrweb.res file as advised by @"Andreas Weiden" in his previous post.

Check this doc and try https://docs.oracle.com/cd/E23943_01/web.1111/e10240/configure.htm#FSDEP219

.Key Mapping in Oracle Forms 10g and Forms 11g | Shortcut keys – Welcome to Oracle

Forms 11g Shortcut keys like in forms6i

You have to try it. Lookup the ascii-code for your symbol and try typing it using ALT along with the code.

Yes I tried it, ALT+20B9 (₹ ascii code) but nothing happens, it treats my code as text.

20B9 is no an ascii-code, try 8377 instead. And, be sure to use the Numpad for the numbers.

This is what I see in my application.

You have to press the ALT-key, keep it pressed, and then type the numbers on the numpad (the right part of the keyboard).

Yes I tried but in MS word if if press ALT-8377 it shows ₹ symbol correctly whereas when I press the same combination in Oracle forms it shows ╣.

I think the font is missing on that item.

Have you select the rupees font on the specific text_item in the design time ? Check

@"Kalpataru" In my forms it is working fine when I copy paste from word. But when I enter ALT+8377, it is showing some other symbol.See the screenshot below

Kalpataru wrote:

Have you select the rupees font on the specific text_item in the design time ? Check

What do you mean by rupees font and design time?

Do you know we can set the font of a text_item in design time ?

For example Font arial etc etc.

Check the screenshot attached here.

Like this you can select Rupees Font on the text item and try to press the Alt + 8377 or you can try the Microsoft Word Keys.

Yes I know but After changing the font to Arial Unicode MS, nothing happens in my forms application.

8177 seems not to be the correct ASCII-code for the rupee-symbol. For unicode-symbol the trick with the ALT-key doesn't seem to work.

The most comfortable way for the user would be if you write a javabean which captures your keboard shortcut CTRL+ALT+4 and then inserts the sign in the textfield.