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!

Insert spectial character like the Euro sign through SQL*Plus

LauryJul 12 2016 — edited Jul 17 2016

Hi,

I am working with Oracle RDBMS 11g and 12c.

Does someone know how to insert characters like "Euro sign", the way they are like "€" in SQL*Plus?

Of course, it has to deal with the National Character Set.

I have for instance that piecce of code:

pkg_contact.WijzigContact

(pKCO_ID => null,

pKCO_KLA_ID => 101712,

pKCO_TAA_ID => NULL,

pKCO_DATUM =>

TO_DATE('11-07-2016', 'DD-MM-YYYY'),

pKCO_CONTACT_MET => 'Ylja',

pKCO_CONTACTPERSOON => NULL,

pKCO_TYPE => 'Intern',

pKCO_ONDERWERP => 'Overig',

pKCO_VERSLAG => '€ 90,00 Cashback Actie Uitbetaald.'

);

The "€" is not inserted as it is in the procedure.

Thanks by advance for any tip.

Kind Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2016

Added on Jul 12 2016

#general-database-discussions

11 comments

2,435 views