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)
ADVERTISEMENT
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 View RelatedSQL & 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.
Forms :: Exit Without Saving?
Dec 5, 2010I have created one master detail form where on master i have one field with name status and if the status is changed to A it will prompt me to another detail block where i will fill the details and in case after i entered the details and then i decide it not to save and come back to main form without saving...how i can do it . I used go_blok In detail to go to master it goes to master but when i am saving the master the details get saved along with it.I dont want to save the detail and go to master block.
View 1 Replies View RelatedForms :: Saving Form To View On Web
Jan 26, 2010i have developed a form in 9i. can i view the fmx file on web. or tell me the extenstion what name of form should i use to save the form to view on the web.
View 5 Replies View RelatedForms :: Saving Of Multiple Records At One Go
May 17, 2011My query is: I have created a master-child forms on one canvas. In a child form i have to enter multiple records, but after entering every record its prompting me to save it. I want to avoid it and save the entire thing once all my records are entered.
View 4 Replies View RelatedForms :: BLOB Image Is Not Saving?
Nov 12, 2011I am failed to saved image in the table via forms. (Although i have successfully updated the table with a procedure at PL/SQL level).
Here is what i have done.
1) Table created
create table prod
(pcode number,
image blob);
2) Made a form with guidence present at orafaq
3) It reads and saves image BUT enter/execute query does not show the image
4) even the following code gives me 0
select dbms_lob.getlength(image) from prod
Forms :: Saving The Object Group
Dec 13, 2010I've created Object Group which consists of (alert, parameters, visual attribute and property class). Now I want to save this Object Group.
View 3 Replies View RelatedForms :: Saving Records In Tables After Updating
Jun 8, 2013I AM WORKING ON FORM I WANT TO SAVE THE RECORD IN TO TABLES TABLE1,TABLE2 AFTER UPDATING THE
TABLE1..BOTH THE TABLE HAVE SAME COLUMNS'.
WHAT IS THE TRIGGER FOR THAT
Forms :: Database Blocks - Saving Record
Oct 2, 2010i am using form6i & oracle 8i.
i have master -detail form. both are database blocks.
i have inserted values for the master block bt not for the detail record my problem is.. "user should not be allowed" to move to next record of the master block before saving the current record
Forms :: Not Saving - Validation On Age Doesn't Work?
Mar 8, 2011im now doin' my currently program, actually they requesting for an update. I added birth date column in the module,they asked to the request to put a validation on date, such as:
a. under age
b. :txt_ph_birthdate > SYSDATE
c. if :txt_plan_type = 212 then
17 yrs, 5 mos and 29 days and 40 yrs, 5 mos and 29 day - as validation
d. if :txt_plan_type = 214 then
40 yrs and 6 mos and 55 yrs, 5 mos and 29 days - as validation
e. if :txt_plan_type = 215 then
17 yrs, 5 mos and 29 days and above - as validation
they also instructed me to put the validations in birth date after the column of birthdate, which is the :txt_plan_type(list_item) and i put it in TRIGGER (when-validate-item)after i did the codes and compile it., theres no message for error but i think its not working..it working. i already updates also the insert and the other trigger and procedure, i just add the plan type on it.
i havent edit the save button because the as i read the codes the it just call the procedure that i edit.when i run the program and after i encode the data..and when i press the save button, nothing happens or any confirmation.in addition, why is it that my validation on age doesnt work?
heres the
declare
n_months_between NUMBER;
d_same_day_occur DATE;
n_years NUMBER;
n_months NUMBER;
[code]...
Forms :: Saving Excel Files As Object In Oracle?
Feb 13, 2012How can we save Excel file as an objectin oracle. Like we can store image file.
View 1 Replies View RelatedForms :: Stop Saving When Detail Record Is Null?
Feb 5, 2011I have master detail block just consider Forms A as a master and Forms B as a Detail,when my cursor is in form A i try to save the record, it is saved Form A and putting Form B data as null, i have to put a validation to stop this activity, i have to inform the user "Provide values for form B text item",
I created a post block trigger in form A
Begin
If (:FORM-B.TEXT1 is null)l or( :FORM-B.TEXT2 is null)
then
Message( 'provide value for FORM-B');
Message( 'provide value for FORM-B');
raise form_trigger_failure;
ELSE
NULL;
END IF
END;
Im Getting error message and navigation got stopped in last item of form A itself,i need to show error message and cursor control should move to first item of form -B which trigger i have to use for this.
Forms :: Saving No Errors Shown And Neither Record Is Inserted
Aug 23, 2013I have used a template to create a form which has 3 below tables / blocks in the form:
1.'OIFC_INV_DEVICE_TYPES'
2.'OIFC_INV_SECTIONS'
3.'OIFC_INV_DEVICE_MASTER'
The 1st 2 tables are used only to fetch values through a LOV and no insert happen during save and the 3rd has initial values defined and has to insert these values while click on the save (when button pressed trigger) button which has the below pasted code, but no error is thrown and neither the record is inserted,
declare
al_id alert:=FIND_ALERT('popup');
al number;
insert_val varchar2(500);
increment_value number;
MAX_VALUE NUMBER;
rec_check varchar2(1);
[code]....
Forms :: Saving Data From Multiple Datablocks Into New Table?
Aug 19, 2010I have a form with 2 datablocks, datablock 1 is the datablock in which I want to write data too that table within the database.
datablock 1(which i want to insert data too) is:
In forms layout this simply consist of a display box at the top of the screen which is populated by a LOV from another table within the database. The lov value selected will then be placed in the appropriate field of the table. For example the LOV contains a list of every single car make there is. i.e. Renault, Ford, Vauxhall etc
datablock 2 (in which i just want to read data from, and write the data to the table used in datablock1) is:
Below this is my second datablock, which on the trigger 'on-new-form-instance' reads data from an already existing table and displays a list of every single make of car ie, focus, clio, megane, astra etc (tabular layout displaying 12 records at a time). Beside these car models will be a checkbox which is a non database item, originally unticked.
What I want to do is the user selects a car type from the top LOV say Renault for example, then they will go down the list of car models checking each and every model of car Renault makes, i.e clio, megane, etc when these models are all checked, and the user clicks save, it will insert into my table (which is the top datablock) the car which was selected From the LOV at the top, plus each and every car model which has a checkbox checked. So for example, say the user selects Renault from the top LOV and checks models clio, megane, laguna. There should be 3 entries in the table consisting of:
Renault, clio
Renault, Megane
Renault, Laguna
Now I have got it to work partially, in the fact that if I load the screen, select my car type and then multiple models that it will add 1 car type and model to the database but not the others which I have checked. I think I need it to go down each row and check if the value is ticked or something like that? using row id or something?
Here is the code I have so far: Just so you know car_model is the name of my table used as my second datablock, contains all car models as u would expect.
BEGIN
if :model_chkbox = 'Y'THEN
v_model_id := :car_model.id;
INSERT INTO NOTE_ACCESS_DEFAULT (car_type, model_id)
VALUES (:car_type, v_model_id);
end if;
EXCEPTION
WHEN OTHERS THEN
MESSAGE('SQLERRM: ' || SQLERRM);
END;
Another option was to do a loop and go through each record and see if it is checked, not sure how I would implement this but it does seem like a very inefficient way to do such a task, perhaps it would be something to do with when a checkbox is ticked stamp it or something.
PL/SQL :: Text Fields Getting Disappeared After Saving In Oracle Forms?
Mar 1, 2013I have developed a screen using oracle forms.... it has 4 text fields..then a LOAD button.After giving i/p in the 4 text boxes user will save (ctl+S) ..then hit LOAD button ,which will populate the fields below the screen.Everything is working fine but only problem I am facing...when user is trying to save (ctl+S) after giving the 4 i/ps in the text fields....the text fields getting disappeared and also becoming editable...though the data they have already given is being populated in the table..I want ..even after pressing ctl+S...the data should be there & non-editable.
View 2 Replies View RelatedForms :: Saving As JFIF And GIF Works Fine Without Any Compression
Feb 5, 2013I am using oracle forms 10g and basically we have a system that takes over 300 photos on a daily basis, this all works fine and with no issues except for say maybe 2-3 photos a month. Occasionally we will get a 'corrupt photo' (it not actually corrupt, it displays in everything as it should except forms) . When we encounter these photos forms just crashes out and the user is unable to query the record with the associated photo until it is deleted and a new one is taken (or alternatively if we take the photo from the database open it in paint.net and just hit save it will then work). There is no difference that we can see in the photo which doesnt work and those that do work. I have tried using WRITE_IMAGE_FILE to save the photo to disk and Read_Image_File to read from the disk to see if that makes a difference. If i save the file as jpeg and no compression it still crashes, if i save it with low compression it works fine but we lose quality which we dont want to lose. Bitmap wont work at all. Saving as JFIF and GIF works fine without any compression but we still lose quality.
The photo will display fine if we use a javabean to display it but in this instance a javabean is not an option.
One weird thing we noticed is that when we are on the form that crashes with these photos and query back a working photo first, and THEN query the 'corrupt photo' the corrupt photo displays fine, but if we go into the form and query a corrupt photo first forms crashes as explained.
Forms :: Save Record In Table Before Saving Updated Version?
Apr 6, 2013I have a multi record block . I need to implement a functionality where the user updates a field in the record but the form saves the previous version of the record in another table ..
View 3 Replies View RelatedForms :: DDE Package - How To Close Excel File Without Saving Changes / Messages
Nov 19, 2009I need to rescue some valors from Excel, and then close the excel file without saving changes and without messages.
I am using THe DDE package and when using
DDE.EXECUTE(convid, '[Save()]', 10000);
there is no problem, but the changes are saved. I have tried '[Exit()]' and '[Close()]' but always have error message ORA-106555. Is there any way of doing this without errors?
SQL & PL/SQL :: XML Not Saving In A Particular Directory
Jul 16, 2013I want to create a xml file for a particular query and i have used the following
SELECT DBMS_XMLGEN.getXML('SELECT * FROM EMPL_NEW') FROM dual:
the output of this is
<?xml version="1.0"?>
<ROWSET>
<ROW>
<ENO>10001</ENO>
<ENAME>rajkumar</ENAME>
[Code]....
and i need to save this as .xml file in a particular file directory in client machine and i have coded like this
DECLARE
F UTL_FILE.FILE_TYPE;
MYCLOB CLOB;
DIR_STR varchar2(100);
BEGIN
DIR_STR:='XML';
SELECT
DBMS_XMLGEN.GETXML('
[Code]...
XML is the name of directory name i have created in my user and I have also created the directory manually in D:/xml.
UTL_FILE package access given to public..
but still this error(refer the pic) exists!!
Saving Email In Oracle DB
Aug 23, 2011if it is possible to save an email send from an ORACLE pl-sql packages in the Oracle database it self? The email is in my case created and send directly using the oracle utl_smtp-package.
I have no problems with attaching doc's and so on in this mail. But i simply cannot find a way to save, the email i'm sending in the Oracle-database. The purpose of saving the email in the DB is that i want to be able to reopen an send email, to se exactly what was send.
SQL & PL/SQL :: Saving Procedures With Compilation Errors
Feb 21, 2010When creating objects, is there a way telling Oracle not to store(overwrite) procedures or other DDL in the database until the statements have no compilation errors?
View 4 Replies View RelatedSQL & PL/SQL :: Mail Reading / Saving Through Package Or Procedure
Nov 14, 2011sample code to read attachments in inbox(from POP3 mail server) using plsql package or procedure.
View 6 Replies View RelatedSQL & PL/SQL :: Local Timezone With Day Light Saving Time?
Oct 22, 2011Order time is not properly displayed in the local timezone format and day light saving calculation is also another issue. Description:
We have web application & a centralized database where users can create orders globally. When orders are created time is saved in UTC format in the centralized global database.
somehow along with the UTC order time, timezone description is also being stored in one of the Database table as
UTC time as: '28-NOV-2010 11:24:54 PM'
Timezone description:
(GMT) Casablanca, Monrovia
(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London
(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
(GMT+01:00) Brussels, Copenhagen, Madrid, Paris
(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb
(GMT+01:00) West Central Africa
(GMT+02:00) Athens, Beirut, Istanbul, Minsk
(GMT+02:00) Bucharest
(GMT+02:00) Cairo
(GMT+02:00) Harare, Pretoria
(GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallin
.....
...
With this information how can I map timezone description to V_$TIMEZONE_NAMES. I read Oracle automatically converts to local timezones by considering day light saving timings when TZNAME is given as input with the datetime. by using above timezone descriptions how can I get TZNAMES which are in V_$TIMEZONE_NAMES.
Client Tools :: Saving A Database To File?
Oct 10, 2011I am connected to an oracle database on campus thru my laptop. The interface i am using is oracle sql developer. We are practicing entering SQL commands. The connection name is DBA120. So, the name of the database is DBA120, correct? Also, I must review the respective ERD (i.e., to know the table relationships) in order to determine the proper sql commands, correct?
Well, in this database connection (DBA120), there are several tables that actually pertain to three different databases, ACCOUNTING, BOOK, and DJ. (I have the respective ERDs.)
I want to be able to save a database to file so I can run it on another computer. How do I save each of the three databases to a file or can't I? Or must I save the DBA120 database? how do i do that? do i save it(them) as sql files?
Application Express :: Current_timestamp Vs Daylight Saving Time
Jan 27, 2013the time in my online application is 1 hour later than is actually is. So 21.30is actually 20.30. This is my code:
select 1
from vex_rondes rde
where rde.datum_einde < current_timestamp
and rde.id = b_rde_idrde.datum_einde
is a date column filled with dates of course ins this format: 10-01-2013 20:45 (10th January 2013 20h45).How can I get this current_timestamp correct?
select 1
from vex_rondes rde
where rde.datum_einde+(1/24) < current_timestamp
and rde.id = b_rde_idbut that's not very elegant nor generic...
Client Tools :: SQL For Saving Query Result In A Text File
May 17, 2012I want to execute a query which automatically saves the result of a set of queries in a text file and have to send that as an attachment thru a mail (using UTL_MAIL or UTL_SMTP) thru a stored procedure...saving the result in a text file in Toad.
View 2 Replies View RelatedApplication Express :: How To Stream The Blob File To The Web Browser Without Saving It
Oct 18, 2012I have a stored procedure that returns pdf as a blob.
Is there any way that this can be streamed to the browser without saving it?
Reports & Discoverer :: Set Path - Error Occurred While Opening Or Saving Document
Jun 29, 2010When I give the report Full path like 'C:FolderNameCurrency2.rdf. Successfully report run.
after changing the registry path like Reports_Path='C:FolderName'
When I click a button to run the report,I received the following errors.
declare
v_report_nameVARCHAR2(100) := 'Currency2.rdf';
begin
Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?usr'||'&report='||v_report_name,'_blank');
end ;
"
REP-110: File Currency2.rdf cannot be opened.
REP-1070: An error occurred while opening or saving a document.
REP-0110: File Currency2.rdf cannot be opened."