Forms :: Unable To Insert Mathematical Symbols?
Feb 20, 2009I have inserted mathematical symbols e.g. quare root,pie etc etc. But when I come to query them they are represent by '?' mark.
View 5 Replies
ADVERTISEMENT
Forms :: Saving Mathematical Equations / Symbols Using 6i?
Sep 4, 2011i want to save mathematical equations / symbols. using forms 6i.
What characterset , font to be used.
(note, my client has equations written in MS Word 2007)
Forms :: Unable To Insert Records
Oct 7, 2012I am getting this error FRM 40508 in inserting data to any table through forms 11g.
eg:
my test table having two columns : id and name
i wrote a simple insert statement insert into test values (:id, :name);
commit;
when i run the application and insert the values, it shows the above error.
when I use the display errors , it shows that there is a violation : ora - 00001 (duplicate values)
however, there is no such value in the database.
The same scenario is repeating with every table I have.
I thing more, when I use the commit_form only without using any manual insert statement, then everything goes well. But with manual insert it all fails.
Forms :: Two Blocks - Unable To INSERT Record
Oct 16, 2012I have this error. To put it simply I have two blocks.
Block1 contains two drop down list with PL/SQL statements for queries.
Block2 contains tabular form created from block wizard (I tried already in manual)
that will catch the result in Block1 queries.
Now I have a button with a trigger when-button-pressed that contains
BEGIN
INSERT INTO dummy1
VALUES ('hello',1,2,3);
COMMIT;
END;
My goal is to add into dummy1 values from :block2.item_name1, :block2.item_name2, :block2.item_name3 but to put it simply I tried these values but I received the same error.
When I run it and first things first click the button, the values will be added into dummy1 table but when I execute the block1 - dropdown list queries and try to press the button. I received the error.
Forms :: Unable To Insert Checkbox Checked Records?
May 23, 2011I have a multi-record block with a check box(:B_ASTHEAD.CB_CHECK) for each record. user can select the record by clicking on the check box. when checked, value is 'Y' and when unchecked, value is 'N'.
when user clicks on 'OK' button (when button pressed trigger), the records which are selected(Checkbox) must be posted to the database table.
L_last_Rec number;
L_first_Rec number;
L_AST COP_DETL.AST%TYPE;
BEGIN
[Code]....
The issue here is , check box selected records are not getting inserted into table when OK button is clicked and i could see that all checked checkboxes become unchecked immediately . But if i comment the --"if :B_ASTHEAD.CB_CHECK = 'Y' then " part, then insert works , but inserts all record.
Insert only checkbox selected records.
SQL & PL/SQL :: Unable To Insert Georgain Characters Using 6i Forms And Reports?
Jun 6, 2013we 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 RelatedForms :: FRM-40508 / ORACLE Error / Unable To INSERT Record
Jan 14, 2013I have an interface composed of five elements:
1.display_item (primary key)
2-list_item (foreign key) / / dynamic list :this is the cause of the error
3-lis_item (foreign key) / / dynamic list
4-text_item
5-button (insert commit)
when I click the button, an error is displayed:
FRM-40508: ORACLE error: unable to INSERT record.in detail: ora-02291 integrity constraint Violated - parent key not found
Note:
-the elements of two lists already exist in the parent table!!
-I use a block based.
-button
commit_form();
SQL & PL/SQL :: Set Mathematical Notations Like (A2 B2 X2 )?
May 8, 2013Is there any function or any character set to save a mathematical notation like (A2 , b2 , x2 ) superscript and subscript in database tables.
View 1 Replies View RelatedSQL & PL/SQL :: Locate Occurrence Of Symbols Combination
Aug 5, 2011My need is to locate an occurrence of symbols starting from "s." (non-capital letter), following by word (with any capital letter at the beginning) and ending with ", " (comma and space symbols).
Ex:
select 'jeklghje, s.Glkgje, u.slgjwek, 904869' as tt from dual union all
select 's.Tklgj, u.slgjwek, 23578, elslgjs' as tt from dual union all
select 's.klgj, u.ekgjes, 238573, dlsjkgj' as tt from dual
I'm looking for occurrence of "s.Glkgje, " and "s.Tklgj, ".
I think some combination of REGEXP_INSTR and REGEXP_SUBSTR should be useful, but I'm not familiar with these functions so good yet.
SQL & PL/SQL :: Unable To Insert Rows
Aug 4, 2010In oracle 11i, unable to insert rows using insert statement. unable to retrieve data using select statement.
View 5 Replies View RelatedSQL & PL/SQL :: Unable To Insert Into Another Table?
Mar 25, 2011i am facing a small problem (!!) while inserting into a table by selecting from another table.
let me simulate.
while execute the select query, i am able to view the records. but when the data inserted into the new table, empty column value is getting inserted. this problem with only one column.
Table 1 : data to be selected.
CREATE TABLE DRI_TEST2
(
FM_COMPANY VARCHAR2(4 BYTE)
)
[Code]....
if we select the select clause we will be able to see the records. but while inserting empty values are getting inserted.
SQL & PL/SQL :: Unable To Insert Rows Into Table
Jun 10, 2011I am unable to insert the rows into table after creation of trigger because Mutating error was getting.
SQL> desc test;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMP_NAME VARCHAR2(10)
EMP_NO VARCHAR2(10)
SQL> select * from test;
EMP_NAME EMP_NO
---------- ----------
ORACLE PC729
JAVA PC047
C PC0729
SQL> create or replace trigger trig_test
2 after insert on test
3 for each row
4 declare
5 ename varchar2(10);
6 eno varchar2(10);
7 begin
8 select emp_name,emp_no into ename,eno from test
9 where emp_no ='1';
10 insert into test2(emp_name,emp_no) values(
11 ename,eno);
12 end;
13 /
Trigger created.
SQL> insert into test values ('PRO','1');
insert into test values ('PRO','1')
*
ERROR at line 1:
ORA-04091: table APPS.TEST is mutating, trigger/function may not see it
ORA-06512: at "APPS.TRIG_TEST", line 5
ORA-04088: error during execution of trigger 'APPS.TRIG_TEST'
SQL> spool off;
SQL & PL/SQL :: Unable To Insert Hindi Language Characters In Oracle 9i
Apr 17, 2013I 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).
Precompilers, OCI & OCCI :: Unable To Insert XML Data Into Type Table?
Dec 16, 2008I want to insert XML data into my ( Oracle 11G Release 1 ) XMLType table using OCCI. I'm getting
ORA-01461: can bind a LONG value only for insert into a LONG column
My XML data size is around 1.5 to 2MB. I have also tried using setMaxParamSize before calling the setString method. But, still I'm getting the same exception.
How to resolve this issue?
Forms :: When Insert Detail The Data Insert Twice Time
Feb 27, 2012when i tried to insert the details from oracle froms..the data inserts twice to the DB..
my table structure:
create table app_sri
(a_id integer primary key,
p_first_name varchar2(30),
p_last_name varchar2(20),
p_age number(3)
);
here a_id can be genarated through simple sequence(pid_seq)...
trigger on app_sri
create or replace trigger pid_trg
[Code]....
form insertion code..
Begin
insert into app_sri(null,'robo','Big',100);
commit
End;
the data inserted...but twice
what is the reason behind the double insertion?
Server Administration :: Unable To See / Insert Chinese Characters In Oracle Database
Jun 14, 2013We are getting problem with the Chinese character set. My current character set is as follows.
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
[code]....
My column description for the table product is as follows.
PART_NBRVARCHAR2 (30 Byte)
PART_DESCNVARCHAR2 (2000)
when trying to insert Chinese character using the insert command below
insert into product(part_nbr,part_desc,cust_name) values('322341',unistr('功'),'test');
I am getting the value when selecting the same record using the select command
select a.part_nbr,a.part_desc,a.cust_name from product a where a.part_nbr='322341'322341¿test
When I running this command on TOAD
select a.rowid,a.part_nbr,a.part_desc,a.cust_name from product a where a.part_nbr='322341'
and manually editing/inserting '功' character in output from select command above. After that I am able to get the same Chinese character when I am running select next time.
Client Tools :: Unable To Insert Euro Symbol In Database With Character Set WE8MSWIN1252?
Mar 29, 2011I am using oracle 9.2.0.6.0 on HP-UX.
I am unable to insert and even display euro symbol from server as well as windows client.
Following are the details of my database server
SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
[code]....
1) When I try to insert € from Db server (using putty) using Alt+0128 it does not print anything (nothing gets typed on the screen). Not even junk characters Also following query does not print anything
SQL> select chr(128) from dual;
C
-
2) while I set NLS_LANG on client and try to insert €, Alt+0128 produces a question mark symbol And following query displays junk character
SQL> select chr(128) from dual;
C
-
Ç
3) Regardless when I inserted couple of rows and tried UNISTR following was the result
SQL> select unistr(v) from t;
Error 45 initializing SQL*Plus
Internal error
$
Forms :: Map Excel Columns On Oracle Forms And Insert It Into Database
Apr 12, 2013I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.
So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.
-more details
I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.
COL1 --> list value of database column
COL2 -->list value of database column
COL3 -->list value of database column
Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.
Forms :: Insert Record Into Lov Through Oracle Custom Forms?
Oct 8, 2013I have a LOV in a custom oracle forms.this lov is linked to a record group.
Presently the column on which lov is created does not contain any value.
I want to insert value into the lov through the forms.
I am not able to insert data into it through forms
Forms :: Insert Into Database
Jul 21, 2010I have a form and 2 blocks(master-detail) and try to add a new record when I press "insert record" button from toolbar. But there occurs a problem. If I don't write 'CLEAR_FORM' just after calling "button_proc" procedure, record is not added into database.I couldn't understand why.
View 8 Replies View RelatedForms :: Insert Picture In OLE?
Feb 22, 2012how to insert a picture in ole
View 4 Replies View RelatedForms :: Unable To Navigate Between LOVs
Aug 30, 2010I have 2 datablocks(non database) 1-Header & 2-Detail. In Header there are 3 Text Item with 3 LOV attached with them. When all the 3 Fields are filled (with their respective LOVs) then Detail records are populated.
However if I am choosing LOV for the 1st Item and then clicking the 2nd Item, Again if I wish to go back to the 1st Item LOV I am unable to do so. That means my issue is I am not able to navigate to the 1st item in Header to call its LOV if control is in in the 2nd Item.
Both the Header n Detail have the following property:
Navigation Style : Change Datablock
Previus Navigation DataBlock : Null
Next Navigation DataBlock : Null
Forms :: Unable To See A Canvas On Screen?
Aug 6, 2010I have an form with a few canvases already in it. The problem is that I want to see a particular canvas which shows the toolbar at the top of the window but it dosent show up on the form. I checked the property palette and the canvas is visible. There is also an other canvas right at the top of the form. How do I move the other canvas down if this is covering the toolbar canvas. How do i move the canvas down as it dosent show any X position in its property palette.
View 1 Replies View RelatedForms :: Unable To Save Record
Oct 21, 2010the data not save the record the item CMPID not generate a number or id to press button NEW
secondly to click the button SAVE they not save the partcular transaction.
Forms :: Unable To Delete Record?
Feb 2, 2012when i tried to delete the record by clicking the delete button which has the trigger code as
delete from emp where employee_id=:e_id; commit;
it wasn't. and showed the message as
---FRM-40508: ORACLE ERROR: Unable to INSERT record.
if i change the EMP ID item property "database item" to "NO"..then i can able to delete the record..but, now i am unable to insert the record form the same form...
Forms :: Frm-41214 - Unable To Run Report
Sep 26, 2008i tried to run the report from form in oracle forms 10g, its raising the below errors:-
frm-41214: unable to run report.
on the same time, i have successfully run the report, which one is developed newly.
problem raising report is migrated from 6i to 10g.
my os xp, db is 10g, forms and reports is 10g
Forms :: Unable To Get Whole Form On Screen
Mar 22, 2011i am not able to get whole form on the screen. some part of the part is missing and even there is no scroll bar to slide the form. I have also change the form applet parameter..my screen size is 1024 x 768 and this is same as of the size of form applet.
View 1 Replies View RelatedForms :: Unable To Connect To Destination
Oct 2, 2007I m using Oracle Forms 6i and Oracle 10g Express Edition. I am having the following error message when I am trying to connect to the database from client.I have dont following configuration in my client's FORM's TNSNAMES.ORA file.
0001 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bankvigil)(PORT = 1521))
(CONNECT_DATA = (SID = XE))
)
In the above configuration
0001 = my connect string.
BankVigil = My Oracle database server hostname.
Forms :: Unable To Put A Check For A Form?
Jul 5, 2010I have a leave form where I need to put a check which prevents the user from entering 'sick leave' if the employee hasn't completed 3 months in the company.This is the code I've written:
SELECT ABS(MONTHS_BETWEEN(t.start_date,sysdate)) INTO l_date
FROM hrp_per_all_people_f t
WHERE t.company_id = :parameter.p_company_id
AND t.employee_number = :parameter.p_employee_number
[code]...
The absence_type_id = 21 is for 'sick leave'. I can't figure out why this is not working. When I do enter 'sick leave' for a new employee I do not get any checks and neither am I able to save the changes.
Forms :: Unable To Generate Reports
Jan 25, 2011I am using the following code to generate my report
pat:= :global.path||'us01127p4';
run_report('heboracle1.pace.internal:7778',
'r1',pat,'c:','c:','pdf','pacerep',pl_id,'yes',
'&co_code='||:global.co_code||'&type_sl='||mtype_sl||'&prog_sl='||:global.prog_sl||'&mode='||'default'||'&desname ='||:global.user_fname||'&destype='||'cache'||
'&to_no='||:to_doc_no||'&year='||myear||'&from_no='||:from_doc_no,'no','no','','wide180');
When i set my param form variable as 'Yes' the report parameters window pops up and when i press submit query the report gets generated. But if i set param form to 'No' then i get a msg saying
TERMINATED_WITH_ERROR-Report output aborted ORA-0000
if i put an exception i am getting a same msg.
The same code is working fine for other forms.