Forms :: How To Access Oracle Database From PDA Device

Feb 21, 2012

I have one PDA device. I need to run a Oracle form developed in Oracle forms 6i on this PDA by connecting it to the Oracle 10G database running on Linux Server.

I need to know is there any Oracle client for windows 6.0 OS. if yes then how can i install it on PDA and access the Oracle database through forms.

View 1 Replies


ADVERTISEMENT

Forms :: How To Send Sms To Mobile Device Using Oracle 6i

Oct 19, 2013

I want to send sms to the mobile using Oracle form 6i.

View 8 Replies View Related

Forms :: Connect Oracle Software On More Than One Device

Oct 20, 2012

i finished from design and programming the program how can Connect this program on more than one device

View 7 Replies View Related

Windows :: Connect Forms 6i With MS Access Database

May 26, 2013

How to connect forms 6i with ms access.

View 1 Replies View Related

Forms :: Fingerprint Device Connectivity With 10g?

Mar 5, 2011

I am working on 10g. I have to capture and retrive thumb impression through biometric device on forms. And then store it in database.

Already working in VB . I have its jar files also.

View 1 Replies View Related

Access Oracle Database From Root User?

Dec 18, 2012

i have an linux instance running oracle 11g as oracle OS user. i am able to connect the DB from clients.

i need to access this DB from OS root user. what should i do.

View 7 Replies View Related

Forms :: Communication With Serial Device (via COM1)

Jan 3, 2012

Is 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.

View 5 Replies View Related

ORA-12547 / TNS / Lost Contact / Access Oracle Database 11.2.0.3

Dec 7, 2012

I installed a server on a Linux server Oracle11.2.0.3 5.8 from 64 bits.The user who installed the Oracle software is "oracle" and belongs to oinstall and dba groups.

ID ORACLE
uid=503(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),506(cvargas) context=user_u:system_r:unconfined_t

The software has been installed correctly and have been able to create two databases. As a requirement of the application, you must create an operating system user that launches processes.This user belongs to dba.But when trying to access Oracle via sqlplus gives this error:

-bash-3.2$ sqlplus davinci/xxxxxxx
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 7 23:22:40 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:

However, if you connect using a network descriptor works correctly.

SQLPLUS DAVINCI/xxxx@tns_alias

So there must be a problem with access to local resources.This user has the same profile file variable (. Bash_profile)

View 6 Replies View Related

Windows / .NET :: Procedure To Connect To Oracle Database From MS Access?

Nov 29, 2012

let me know the procedure to connect to Oracle Database from Ms-Access.

We are using Windows as Operating System.

View 1 Replies View Related

Forms :: Send Message To Lantronix Network Device?

Sep 15, 2011

how I can send a message from Oracle Forms 10g to a Lantronix terminal server? It is a TCP/IP front end to a serial port controlling a warehouse carousel. We want to send a command string to a ip_address:port_number in raw mode. We have tested it using a telnet session. I develop in PL/SQL, just never used forms.

View 2 Replies View Related

Forms :: 10g - Send Text Message To GSM Mobile Device?

Aug 28, 2010

through oracle forms 10g how can i send a text message to a GSM mobile device...

View 2 Replies View Related

RAC & Failsafe :: Oracle Rac Raw Device As Shared Storage

Jul 24, 2012

I wish to install 11g r1 RAC on my laptop having linux 4 as platform (on vmware) , for that i prepare 4 partition for that (on node1)

/dev/sdb1 - for ocr
/dev/sdb2 - for voting disk
/dev/sdb3 - for asmdisk group
/dev/sda5 - fro asmdisk group

by assuming external redundancy for ocr and voting disk i kept only one disk

and i configured following in /etc/sysconfig/rawdevices

/dev/raw/raw1 /dev/sdb1 -- ocr
/dev/raw/raw2 /dev/sdb2 -- voting disk
/dev/raw/raw3 /dev/sdb3 -- asmdisk group
/dev/raw/raw4 /dev/sdb5 -- asmdisk group

and my question is how node2 can understat these raw device as shared storage?

View 1 Replies View Related

Error In OS Level Authentication For Oracle 11gR2 Database Access?

Mar 18, 2011

We have an issue regarding OS level authentication to access Oracle 11gR2(11.2.0.1) database.

Our environment -
UNIX - AIX 5.3 (OS user id password is having kerberos security).
Oracle 11.2.0.1 (32 bit client) installed in server 1
Oracle 11.2.0.1 (64 bit server) installed in server 2.
Everything works fine when we created a general userid test_db in the database and connect through sqlplus test_db@dbname.

But when we try to use the option of OS level authentication using "sqlplus /", it throws following error and could not be connected.

ERROR: ORA-12545: Connect failed because target host or object does not exist

I have created the same OS user name in database (with external password authentication) with prefix OPS$. we have set ORACLE_SID as well.

View 1 Replies View Related

Server Administration :: How To Access Active Directory With Oracle Database

Oct 12, 2012

How to access Active directory(Microsoft 2003) with oracle database 11g.

View 1 Replies View Related

Enterprise Manager :: Client V9.2.0 Fail When Access Oracle Database 8.1.7?

May 12, 2010

behaviour of oracle enterprise manager. i want to edit a table of a database. after i clicked on the table the oem crashes without any messages - simply disappearing.

i installed oracle9i release2 V9.2.0.1.0 windows client and want to access an oracle8i V8.1.7 server on linux.

View 4 Replies View Related

Forms :: Import Access Data To Oracle?

Jun 2, 2010

when i create db link then it show below:

SQL> conn sys as sysdba
Enter password: ********
Connected.
SQL> show user
USER is "SYS"
SQL> create database LINK orafaccess using 'ORAFACCESS';
Database link created.
SQL> desc emp@orafaccess
ERROR:
ORA-02085: database link ORAFACCESS.APEX.COM connects to HO.WORLD
SQL>

View 10 Replies View Related

Forms :: Data Field Access In Oracle

Feb 26, 2013

Is there a way to apply changes to a data field on oracle forms for specific users?

For example, I have an oracle form that applies the below masking code for a certain field called CUSTOMER_ID

IF :SYSTEM.BLOCK_STATUS = 'QUERY' THEN
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_TRUE);
ELSE
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_FALSE);
END IF;

But I only want this masking to be applicable to CERTAIN users. For example, the psuedo code would be like

IF :SYSTEM.BLOCK_STATUS = 'QUERY' and USERS_LIST = 'SUPERVISORS' THEN
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_TRUE);

Note that this users_list is a group of oracle database users, so I am a member of this group. Also note that this form is applied via the web via the application server.

View 1 Replies View Related

Server Utilities :: How To Load Data In Oracle From Microsoft Access Database (MDB) File

Aug 24, 2012

I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.

View 6 Replies View Related

SQL & PL/SQL :: Access Attributes Of Objects Of Nested Table In Member Function Of Oracle Database

Nov 17, 2011

I have created two types and a list of the first type:

create type type1;
/
create type type1_list as table of ref type1;
/
create type type2;
/

I have now just created the two types as follows:

create type type1 as object(
id# number
);
/
create type type2 as object(
attribute1 type1_list,
MEMBER FUNCTION function1 RETURN NUMBER
);
/

Ok, I've created the tables (I don't know if it's necessary to point out my problem)

CREATE TABLE type1_table OF type1;
/
CREATE TABLE type2_table OF type2
NESTED TABLE attribute1 STORE AS nested_type1_list_table;
/

And what I wanted to do now is to implement the member function1 and check something of the attributes of type1 in the list of attribute1... And that's where my question occurs, how does it work, I can't figure it out. I tried something like this:

Quote:
create or replace
TYPE BODY type2 AS
MEMBER FUNCTION function1 RETURN NUMBER AS

[Code]....

But I don't get the right way, it doesn't work

View 4 Replies View Related

Forms :: Tracking Remote Desktop Access Using Oracle?

Sep 27, 2013

I have a form developed using Oracle 10g Forms Builder. It is deployed on server. I need to track who is remotely accessing the desktop and running this form. How can we track this. Are there any webutil commands to trace the application used to access the desktop? What is the work around for this?

View 2 Replies View Related

Replication :: Oracle Forms 10g Access Key Property For Button

Jan 22, 2013

just i want to ask about access key property for button..i'm using oracle forms 10g ,

suppose that i have 3 buttons in a module like the following:

1- buttonOne --access key property for this button is "1"
2- buttonTwo --access key property for this button is "2"
3- buttonThree --access key property for this button is "3"

when run this module then the user press "1" the trigger when-button-pressed not fire until he press Alt+1...how the user can press the "1" only to fire the trigger when-button-pressed? just like form 6i?

View 6 Replies View Related

Restriction On Database Access

Oct 17, 2012

I have one question regarding database access. I have one database server on which 3 databases are running. I want to restrict each database access for particular group only , so if anyone outside of this group try to access the database then they can not access the database.

Question is end user never login to Database server and access the database , they always connect to the database using different tool like Pl/sql dev,sqldev etc.

Is there any option through which I can make database access within group only ?

View 1 Replies View Related

XE :: Can't Access Database 11g EE In Browser?

Aug 25, 2013

Database 11g Enterprise Edition.

Probably if I give the installation procedure I went through and specified Error messages,. Installation Option: - Create and configure database was selectedSystem Class: -Sever Class was selected Install Product:-Oracle Database Installation= Succeeded· Prepare= Succeeded· Copy files= Succeeded· Setup files= SucceededOracle database configuration= Succeeded· Oracle Net Configuration Assistant=Succeeded· Oracle database configuration Assistant=Ignored· Oracle configuration Manager Configuration (optional)=Succeeded In the process of the Install Product the following Error messages

[code]....

View 1 Replies View Related

How To Access Database From Another Client

Feb 28, 2013

i have local network 3 pc , and i install database 11g r2 on my server( windows server 2008 r2 64 bit ) ..

i want to access this database from another pc (windows 7 64 bit) to query , insert and modify .

View 2 Replies View Related

PL/SQL Query To Import ACCESS Database

Jul 11, 2007

I am New to Oracle and PL/SQL. How to import ACCESS database to Oracle(10g) using PL/SQL.

View 1 Replies View Related

Access Database In Network Using Toad

Feb 7, 2007

I'm using Oracle10.0 as database for my project and I have installed Toad as front end tool for the Oracle. Now I want to access the database in the network using the Toad.

My question is, is it compulsory that oracle should be installed in every system to access Toad or any thing can I change in the server system to access the database from other systems in the Network.

View 1 Replies View Related

Enterprise Manager :: How To Access Two Database With Same Name Using OEM

Apr 20, 2012

I have two differenct databases with nsame name. Database 1 named DBX is on server SERVERX used for dev Database 2 named DBX is on server SERVERY used for test

I want to install OEM Agent on both server and access from one single OEM 11g Grid control.

What I find is that, the OEM seems to get confused when I try to login to the A database from OEM.

How should I configure OEM or Agent so that OEM can be used to login to both DBs?

View 3 Replies View Related

SQL & PL/SQL :: Access Table From One To Another Database On Same Server

Jun 22, 2010

How can we access a table from one database to another database on the same server.

Let us say One database is "A" and the Other database is "B" both databases are running on one server "ABCD".

My question is how can we access a table from database B to database A.

View 21 Replies View Related

Forms :: Access To Professional Dataloader But Not To Forms Playback?

Jan 17, 2012

We have access to Professional Dataloader but not to Forms Playback? what Forms Playback functionality would enable to do and why you think this access has been stopped (something to do with accessing Unix) - we are working with a third party

If we have paid for 2 licenses for Professional Dataloader should we have Forms playback?

View 1 Replies View Related

SQL & PL/SQL :: How To Send Sms To Mobile Device

Aug 5, 2011

My Boss give me a mission:

How oracle send a s.m.s.(Short Message Service) to mobile device? Is there any examples or implement documents for reference?

View 1 Replies View Related







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