Forms :: Communication Form Serial / Parallel Port Via Oracle?
Jun 14, 2005I want to connect a biometric device with my system, through serial port / parallel port. And want to permit only valid users to the system.
View 18 Replies
ADVERTISEMENT
Forms :: Transfer Data From Oracle 9i To Serial Port?
Feb 14, 2012I want to transfer data from Oracle form 9i to serial port.
Serial port is connected to electric board to show.
Forms :: Communication With Serial Device (via COM1)
Jan 3, 2012Is it possible to communicate with a serial device (via COM1) with oracle forms / webutil? I am able to communicate in java using RXTXcomm, but I am having problems making a bean that uses it (getting security errors and yes, I have signed the jars).
Basically, I have a scale hooked up to my COM1 port and want to be able to send commands (zero and tare) to it and read the weight from it through a form or java bean.
Forms :: Read Data From Serial Port?
Jun 16, 2004I'm trying to read some data from external device via COMM Port.
Application is running n server and device is connected localy on my PC.
My device iz DPI605R for purpose of� pressure measuring.
PL/SQL :: How To Run DBMS_JOB In Parallel And Serial
Jul 26, 2012I have total 8 procedure to run in parallel . and after that my 9th procedure should run.
below is my job submission procedure
create or replace procedure DURATION_ALARM_WEEKLY as
l_job number ;
begin
dbms_job.submit(l_job,'begin ALARMS_WEEKLY_CALL_OUT ; end;');
dbms_job.submit(l_job,'begin ALARMS_WEEKLY_CALL_IN ; end;');
dbms_job.submit(l_job,'begin ALARMS_WEEKLY_DURATIN_OUT ; end;');
[code].......
what is the syntax I have to do in my FINALE procedure . using DBMS_ALERT.REGISTER , DBMS_ALERT.WAITANY .....?
Forms :: Serial Number In Tabular Style Form?
Feb 9, 2010I need Sequence generate in each row in tabular style form
Like
FA0015
FA0016
FA0017
(I dont want to use sequence because when i delete the row its conceder delete row in sequence )
Automatic Storage Management :: Re-Balance Operations Run In Serial Or Parallel
Nov 27, 2012Background: We are migrating a lot of databases from one SAN appliance to another. We are doing this by adding new disks from the new SAN appliance to the existing disk groups, re balancing, removing the old disks from the disk groups, and then re balancing again.
Question: If I execute two ALTER commands with the same power on 2 or more separate disk groups, do both operations start executing right away? Or do they queue up and execute one after another?
I ask because we would like to queue up several re-balances so we don't have DBAs watching status bars all day.
Forms :: Finding Out Port Number And Oracle ID For Compilation?
May 21, 2010Is there any way i could figure out what is the current port number used in an existing setup of oracle forms in a linux server.
Is there any specific oracle id i should use to compile oracle forms on server?
Forms :: Change Port 1521 In 6i And Oracle Database 8.1.7?
Jun 4, 2011How can we change Port 1521 in forms 6i and oracle database 8.1.7
View 1 Replies View RelatedCommunication Failure In Oracle AQ With Firewall ON
Jul 21, 2010I have two machines with oracle 11g . Both having ODP 11.2 Beta. I've to communicate between these two machines using Oracle Advanced queuing. The message sent from one machine will reach the second machine only if the Firewall of both machine is OFF.But based on requirement, we cannot switch OFF firewall or add exceptions as ports or applications.
View 1 Replies View RelatedListener Port Conversion To Static Port
Mar 2, 2012For every connection, oracle listener creates a unique dynamic port. Is this can be made static port for all connection? This a query raised in our penetration testing.
Listener log Sample :
02-MAR-2012 17:40:28 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.3.12)(PORT=3773))
02-MAR-2012 17:39:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.84)(PORT=38192))
Forms :: How To Generate Serial Number
Aug 23, 2011how do you generate serial numbers? i have an invoice where i have to add items, so i want the numbering to start from 1 everytime i start a new form and increment by 1 as i i enter a new record. For this i have put my code in when-new-record-instance but problem is if i delete a record and enter a new one, the serial number starts from the nex number.
For ex. if i have 4 items with serial numbers 1, 2, 3, 4 and i delete the item at no. 3 and add a new item , the serial number comes as 5.
proper code to generate the serial numbers?
Forms :: Generating Sequence - Get Serial Number?
Dec 21, 2011i want to get serial numbers in oracle forms. i have one data block with 10 rows and a non database display item with corresponding length as that of the original data block .
when ever i am executing the form i want to see the serial number generated in the display item and when i inserted a new item or row it should show the corresponding rownum.
eg:
empno name serialno
5 tom 1
4 tinil 2
6 sofy 3
7 john 4
1 albert 5
2 michel 6
i want to get the above answer using forms.
Forms :: Applying Serial Number In Detail Block
Sep 5, 2011I have form with master detail relation ship (invoicing form) the detail block is tabular, displaying upto 7 records...
Now my clients wants to show the serial number along with each record while feeding the data (this includes when insert, editing, deleting / clearing records) he wants to see the serial number as in MS access / MS techniques.
I tried to use the system variable to use :system.cursor_record; but this dose not works.(in insert/edit/delete/clear record)
Performance Tuning :: Parallel Index With Non-partitioned No-parallel Table?
Apr 30, 2012If we have not set parallel degree for a table then we can ( try to ) force parallel execution on a table using a parallel hint Does this 'parallelism' works on the index search in the query as well?
In which situations non-parallel non-partitioned table but parallel index (degree>2) will facilitate a query?
Forms :: Simple Data Block - Serial Number Generation
Jun 2, 2010I have created simple data block by wizard and taken tabular layout 10 rows and 6 columns
i want to generate serial number on first column .....
what need to use..?
Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW
Apr 17, 2012I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
Forms :: Restrict User To Enter Serial Numbers Of Product In 3 Level Block
Apr 24, 2012I have a sale invoice form with 3 data blocks.
Data block 1- master_blk : For date/customer of sale invoice
Data block 2- detail_blk1 (detail of the master block - For products and qty)
Data block 3- detail_blk2 (detail of DETAIL_BLK1 For entering serial numbers of products)
My requirement is that whatever quantity user enter in data block 2 against each product he must enter equal number of serial numbers of that product in data block 3.
For this I have created on item (cnt_iteml : to count product's serial numbers in block3 ) in data block 2, and on summary item (t_serial_no ) in block3.
Whenever user changes in quantity, cnt_iteml: item is populated with t_serial_no in block3 of that product by following trigger on quantity column.
POST-Change Trigger ( quantity column )
:stock_transactions.cnt_itl:=:serial_numbers.t_serial_no;
Following trigger is written on block level at data block-3 to populate cnt_iteml with t_serial_no.
PRE-RECORD
IF GET_BLOCK_PROPERTY('SERIAL_NUMBERS',STATUS) IN ('CHANGED') THEN
:stock_transactions.cnt_itl:=:serial_numbers.t_serial_no;
END IF;
Above triggers are fulfilling my requirement except following condition.
If user after entering serial numbers in block 3 and without saving goes back to block2 and try to navigate to another record he gets a message asking him to save changes by forms. At this time if user presses no then cnt_itl item is not been populated with t_serial_no item's value.
What I want in above condition is that if user was inserting new record cnt_it item should be populated with 0, so that he shouldn't be able to save this record. And If he was updating then cnt_itl item should be populated with actual no of records in database against that product.
Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black
Sep 23, 2011I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.
Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.
Forms :: Data Receive For COM PORT
Jul 3, 2010i want data receive from COM PORT. it's is Possible.Forms 6i and Oracle 8i
View 1 Replies View RelatedForms :: How To Hide Port From Link
May 4, 2010how to to hide the port number from the linkof my oracle web application???I call my application through a url like:[URL]...
how can I customize this url??
Port Number For Oracle RAC
Sep 18, 2013I have a two node RAC setup using SCAN, and I have two databases on it. Can they have the same port number?
View 7 Replies View RelatedOracle Port On Localhost Machine?
Oct 14, 2011How to know the oracle port no on localhost machine.
View 1 Replies View RelatedEnterprise Manager :: Oracle Port Number
Feb 10, 2012While connecting my oracle with My JDBC driver . i got an SQLException:
public class Orajdbc {
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection
[code]......
i am successfully connected by type 1 odbc driver but while i want to connect it with "ojdbc6.jar" file then i got this exception i already added that jar file to my Environment variable ClASSPATH ..
How to find port number of my Oracle Service?
Networking And Gateways :: Port Forwarding In Oracle 10g
Sep 8, 2012i want to online my oracle 10g database but when i make connection string then i don't know what the port i set. I set default port 1521 but it not work on client site .
View 4 Replies View RelatedForms :: FRM-10142 / HTTP Listener Is Not Running At Port 8888
Jul 6, 2005I am still facing the following error even though i have started the OC4j instance,
"FRM-10142: The HTTP Listener is not running on <computernam> at port 8888.start the listener or check your runtime preferences."
Forms :: Migration Of Oracle Form 10g To 6i?
Apr 19, 2011Is this possible to convert oracle form which developed in oracle form 10g into Oracle form 6i. We developed one form in oracle form 10g and we trying to open it oracle form 6i. At start it gives warning about compability by ignoring this it open in form 6i, but control mismatch and not showing the trigger code that type of problem we faced. tool of that convert the oracle form 10g into 6i.
View 1 Replies View RelatedForms :: Matrix Form In Oracle
May 20, 2013Is there any possibilities to make matrix form just like matrix report.
one is the month column which increase horizontally other is emp_name column which increase vertically and sal column which show the salary of each employee in each month.
Forms :: Why Other Browser Cannot Run Oracle Form Without IE
Oct 9, 2012Why Other Browser cannot run oracle forms without IE.
i want to use other browser for oracle form like firefox,google chrome etc not IE.
Forms :: How To Convert Oracle 10g Form To 6i
Oct 24, 2013How to convert Oracle 10g Forms to Oracle 6i Forms ?
View 2 Replies View Related