Forms :: Language Specific Characters (apostrophe)?

Jun 2, 2010

I have a problem concerning the display of language specific apostrophes (Czech, e.g. in "Další") in Oracle Forms (Labels/Prompts):

In my local Forms Developer /OC4J they are displayed correctly, but when I copy the module onto the IAS (Unix) the are not shown correctly.I already tried several fonts, but none is working for me.

View 2 Replies


ADVERTISEMENT

Forms :: RTF Changes Not Shown For Specific Language

Mar 20, 2013

cookiemonster wrote on Wed, 20 March 2013 22:01Or if the user does anything to wipe the modified data - clear block, enter query etc - forms will also raise the alert.

i've uploaded a new RTF for Spanish but wen i login with the Spanish creds and run the program. Its not showing the changes i've chosen the right language and territory code.

View 1 Replies View Related

SQL & PL/SQL :: Restricting Other Language Characters?

Jan 24, 2011

I need to give validation for not allowing french or arabic or hindi alphabets or numbers except for only english alphanumeric letters.

I understood how to restrict special characters or spaces .

regexp_instr(i, '[^[:alnum:]]') = 0

This function allow only characters and numbers in English language and doesnt allow special characters.

I need to restrict further by not allowing any other language characters or numbers except only english alphanumeric letters.

View 37 Replies View Related

SQL & PL/SQL :: Unable To Insert Hindi Language Characters In Oracle 9i

Apr 17, 2013

I am unable to insert string of Hindi language characters with 1800 character length in column having data type VARCHAR2(4000).

I am getting error "ORA-01461: Can bind LONG value only for insert into a LONG column"

NLS parameters for database are :

PARAMETERVALUE
NLS_LANGUAGEAMERICAN
NLS_TERRITORYAMERICA

[Code]....

Is there any way to insert this string in VARCHAR2 column? I can't change data type to CLOB (with which I able to insert this string).

View 1 Replies View Related

Security :: Audit Specific Statement On Specific Table By Specific User?

May 29, 2012

I'd like to know if it is possible to track DML actions issued on a specific table by a specific user, for example , i tried :

AUDIT SELECT on SCOTT.DEPT by HR by ACCESS;

I get an error, where is my syntax error ?

i want to know if it's possible to do it without trigger ?

View 7 Replies View Related

SQL & PL/SQL :: How To Replace Apostrophe

Jan 4, 2011

I have a table MOM i.e. Minutes of meeting where important points in a meeting are captured. Now these points may include words like, "don't" or "can't" which will be recorded first in a text file and later copied to the table MOM. Rest of the details are unimportant. All I want to know is how do I enter these words without getting the ORA-01756 error? Do I need to always correct them before entering or is there perhaps another way?

View 2 Replies View Related

SQL & PL/SQL :: Using Apostrophe / Quotes In A String

Feb 9, 2011

Here is a sample function which takes in a string of CSV fields and prints the third field :

create or replace function restr(istr varchar2) return INTEGER
is
var_1 varchar2(30);
begin
dbms_output.put_line('input:'||istr);
select regexp_substr(',' || istr,1,3,null,1) into var_1 from dual;

[Code]..

When I pass an input string as :

JOHN,MARY,O'DONNEL,O'CONNELLY,MARK

with quotes/apostrophe in it to the function then it prints the input string in the first dbms_output but errors out at the select with ORA-01760.

how we can use the quote/apostrophe character here ?

View 6 Replies View Related

Forms :: Setup Arabic Language

Aug 8, 2010

My arabic data appears like ???????

How could I setup Arabic for forms , database?

I have 10G oracle database, forms,reports.

View 13 Replies View Related

Forms :: Multi-Language Support In 6i

Mar 12, 2012

I want to enter data in Arabic and English through Oracle Forms6i.

View 8 Replies View Related

Forms :: Setting Of Urdu Language

Feb 14, 2008

Any one tell me how can i enable urdu in oracle 9i which charter set will be use

View 2 Replies View Related

Forms :: How To Create LOV Via Own Mother Language

Apr 28, 2011

I am using Developer 6i and oracle 8i. when we r create LOV , it's generate by English language. and it's contains 3 button . this r find, ok , cancel button. but now i want this 3 button language show by my mother language(Bangla language). it's possible

View 1 Replies View Related

Forms :: Change Language - English To Arabic

Apr 18, 2010

Which is changing language in form from English to Arabic and vise versa during run time when I validate from item to another one ..

View 5 Replies View Related

Forms :: Get Current Language From Firefox And / Or Internet Explorer

Feb 25, 2010

I am looking for a possibility to get the current language from Firefox and/or Internet Explorer.

I searched through the Mozilla Developer Center but could not find an interface to realize that. For IE I also didn't find anything.

I know that IE adapts the current system language from the OS, but can I readout this value?

View 1 Replies View Related

Forms :: Form Where User Can Search Database On Basis Of Language And Name?

Jul 2, 2013

There is a table called cd_details. It has fields like id, name, language, type etc.I need a form where the user can search the database on basis of language and name and then display the other details. I used a data block wizard and given a push_buttonwith (execute_query). But it's very clumsy. For eg, if the user presses next the next button then all the records are being displayed. Is there any way to do this thing in a better way?

View 13 Replies View Related

SQL & PL/SQL :: Removing Special Characters And Get Desired Characters From Column Values

Jul 23, 2013

create table test
(
name varchar2(50),
descd varchar2(50)
)
insert into test values ('kethlin','da,dad!tyerx');
insert into test values ('tauwatson','#$dfegr');
insert into test values ('jennybrown','fsa!!trtw$ fda');
insert into test values ('tauwatson','#$dfegr ,try');

how do I get the first three characters and last three characters from name field and remove all the junk characters from descd field?

so my o/p be like;

Quote:('ketlin','dadadtyerx')
('tauson','dfegr')
('jenown','fsatrtw fda')
('tauson','dfegr try')

View 6 Replies View Related

Displaying Records Between Specific Times On Specific Dates?

Apr 11, 2011

I have a database which consists of various orders and various field.

I have a variable called createddatetime . I want that whenever i should run the database it should display records from

Yesterday 06:00:00 am to Current Date 05:59:59 am

Now to implement this i tried to put this syntax

and to_char(Createddatetime,'dd/mm/yyyy HH24:mi:ss') between 'sysdate-1 06:00:00' and 'sysdate 05:59:59'

But nothing comes up

where as definitely there are records between times because when i do and Createddatetime between sysdate-1 and sysdate I see valid records coming up.

View 3 Replies View Related

Forms :: How To Set A Format Of Characters

May 30, 2013

i have to enter pan_no through my form into database, and pan_no format is like BWHPK2334M as first 5 is alphabets then 4 letters and last one is alphabet, how to validate it in my form. can i do this by set fomat mask in property palette and if yes then how, oterwise the 2nd option may be is trigger when validate item, but with which format i should match the entered data.

View 5 Replies View Related

Forms :: Arabic Characters?

Mar 17, 2010

problem is that when i call run_product to generate a report from a form i have the name of employee in arabic characters appear in wrong form. yet when i use query from forms directly or from reports directly. name appears correct.

i want the arabic charcters to appear correct when i call to show report from a form..

View 6 Replies View Related

Forms :: Developer 9i AS Using Specific Item

Apr 15, 2010

I develop a form using Devloper9i AS, oracle 9i, Winxp

I need to use items like "ActiveX Control, OLE Container, Sound " but they are marked as obsolete by Developer9i AS;

so how can I use like this type of items when I establish a form design ".fmb" .

View 2 Replies View Related

Forms :: Clear Specific Block?

Sep 21, 2010

i have 4 blocks in one form.my requirement is this that can i user the clear_block or any other built-in for clear the specific block....

View 2 Replies View Related

Forms :: UTF-8 - Special Characters Replaced With ?

Oct 27, 2010

We have a table with an nvarchar column that we use to store product descriptions.

This field is maintained on a web form created with the htp package.

Whenever a special character is used (ie, the copyright symbol, trademark, etc), the value is stored correctly in the DB. I've verified this because if i query the value in sql developer, i do see the correct symbol.

However, pulling this piece of data out to display in a formtext box (for edit) replaces all the special characters with ?'s.

Our National Character Set value is set to UTF-8.

Is this being caused by our database character set? or is it a web design problem that i'm just not aware of.

I can post code snippets if this isn't enough info...but I was hoping it'd be fairly simple.

View 3 Replies View Related

Forms :: How To Restrict Update In S Specific Field

Jul 9, 2012

I'm trying to restrict update in a specific field in my form . I have set its property(update allowed) to no and still the field is update able. I am also having on-commit trigger in my form level that well display a message and followed by the command commit. is it possible the trigger is overriding the property(update restriction).

View 9 Replies View Related

Forms :: How To Browse Specific Folder Or Drive In 6i

Feb 9, 2010

I want to open any drive or specific folder in forms 6i in when button press trigger like we open any drive and folder in my computer or folder in windows

View 3 Replies View Related

Forms :: After Post Trigger Go To The Specific Item?

Feb 8, 2013

I have this layout

[URL]

and a post trigger insert and update

IF :item1 IS NULL
AND :item3 IS NOT NULL THEN
alert_id := FIND_ALERT('blank_alert');
SET_ALERT_PROPERTY(alert_id,ALERT_MESSAGE_TEXT,'Item3 must have a value.');
v_alert := SHOW_ALERT(alert_id);
RAISE Form_trigger_Failure;
END IF;

My problem was as it fires, the cursor will be on the item1. I've already use

SET_ITEM_INSTANCE_PROPERTY
NEXT_ITEM
GO_ITEM

but it was all illegal. The cursor must be in the item3.

Don't question me why I do not set the item3 to required and why post triggers. It is just that. It is the requirement.

View 4 Replies View Related

Forms :: Variable Can't Hold 4000 Characters

Dec 22, 2011

I have error message when running duplicate : FRM-21011: PL/SQL unhandled exception ORA-06502..I'm trying to hold 4000 characters in a variable like what do below:

if s_str is NULL then
s_str := eachcol.column_name||'{{'||
name_in(name_in('system.cursor_block')||'.'||eachcol.column_name)||'{{';
else
s_str := s_str||eachcol.column_name||'{{'||
name_in(name_in('system.cursor_block')||'.'||eachcol.column_name)||'{{';
end if;

It's simple variable to hold value but still can't get by large string though.

View 1 Replies View Related

Forms :: Records Not Displaying In Specific Text Item

Feb 14, 2012

I have for example two text items(number of records to display is set to 9). What I want is when i go to studentprofile block, it should automatically shows his subjects that are already taken up. the first text item is for 1st semester subjects and the other for 2nd semester.

here is the structure of my subjsec table:

ID number(1)
subj_code varchar2(10)
day varchar2(10)

and for subjects table:

subj_code varchar2(10)
description varchar2(50)
units number(1)
semester varchar2(10)

I restricted subjects that are in 1st sem. So i did something like this in my

DECLARE

CURSOR studgrade_cur IS
SELECT g.stud_id, g.grade, g.subj_code, s.description, s.units, s.semester
FROM studgrades g , subjects s
WHERE g.subj_code = s.subj_code
AND g.stud_id = :Studentprofile.student_id;

[Code]....

View 32 Replies View Related

Forms :: How To Pull Off Report From Builder 6i Within Specific Date(s)

Sep 9, 2011

SQL Plus version Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.1.0 Production
Forms Version : 6i
Reports Version: 6i
O/S : Microsoft Windows Xp professional Version 2002 Service Pack 3

With regards to the above version description here is my query. I have a form which calls report it accepts various parameters like date between, appeal and so on . I want the report to be restricted to the date parameter as passed by the user.Here is my coding which runs report

Declare
Pl_id ParamList;
where_cond varchar2(2500);
Begin
------------Appeal------------------
if
upper(ltrim(rtrim(:appeal)))<> 'ALL' then
where_cond:= where_cond ||'and tbl_donation.appeal_code='||ltrim(rtrim(:blk_ihelp.appeal_code));
else
where_cond:= where_cond||' and tbl_donation.appeal_code is not null';
end if;

-------------Date Option----------------
if
:date_option is not null then
if
:date_option = 'BETWEEN'then
where_cond:=' and tbl_donation.donation_date between '''||ltrim(rtrim(:fdate))||''' and ''' ||ltrim(rtrim(:tdate))||'''';
else
where_cond:=' and tbl_donation.donation_date '||:date_option||''''||ltrim(rtrim(:fdate))||'''';
end if;
end if;

--------------Country-------------------
if
upper (ltrim(rtrim(:country))) <> 'ALL'then
where_cond:= where_cond||'and tbl_donation.country_code='||ltrim(rtrim(:blk_ihelp.country_code));
else
where_cond:= where_cond||'and tbl_donation.country_code is not null';
end if;

-------------Contact Code---------------
if
:contact_code is not null then
if
:contact_code = 'BETWEEN'then

[Code]....

View 1 Replies View Related

SQL & PL/SQL :: Unable To Insert Georgain Characters Using 6i Forms And Reports?

Jun 6, 2013

we unable to insert Georgian language in oracle forms and reports,while we insert it displasys as ? note my database characterset is utf8 and my Client PC NLS_char=american_america.utf8.

View 1 Replies View Related

Forms :: Written English Characters Only In Text Item

Oct 30, 2011

I want written English characters only in text item (I want control in one text item), in my form 10 g but, in same form can be written other language in other text item.

View 1 Replies View Related

Forms :: Oracle Global (variable Name) Can't Hold 4000 Characters

Dec 13, 2011

In current form, i use *pll file to pass Global.<variable name> to the form *.fmb

The problem is that if i copy a string of 4000 characters (which i need to) to Global.<variable name>, it will automatically cut a whole chunk to shorter string (less than 1000).

Is there a better way to that Global.<variable name> can hold 4000 characters?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved