Forms :: Jacob Jar Not Working On Server?

Mar 22, 2010

I manage to configure webutil set up on my local pc, jacob jar is working and I can now export data to excel file.

There's a server dedicated to me on linux. I tried to test my form server. There's no error on webutil but the process stops on the line where excel is called. This is the same problem I encountered when jacob.jar is not working on my local drive.

View 2 Replies


ADVERTISEMENT

Forms :: WebUtil And Jacob Settings In AIX Server

Sep 21, 2010

I am using forms 10G. I have done the setting for webUtil and Jacob in my pc for browse button to be work and it is working fine .I am sending you the attachment ,which i followed for the configuration in my PC.

But can any one please tell me the steps for implement these things in AIX server so that everyone can use my form .I mean how to configure this to utility Webutil and Jacob in AIX server .

View 1 Replies View Related

Server Administration :: Oracle 10g - First Put Server Into Actual Use - Not Working?

Aug 12, 2010

We are using oracle 10g in linux machine which runs as server. And there are around 25 clients which run at the same time parallel to each other. I am new to oracle 10g and also for client-server version of database. I faced some problems when i first put the server into actual use.

-> Users have been created and tablespace is USERS and temporary space is TEMP. RESOURCE privilege is given.
-> Some times login fails for some clients.
-> Some times all the client login will be successful.
-> Query execution will be sometimes fast, but some times it takes too much time.
-> Some times the connection will be lost and again I have bring UP the server.

to maintain the oracle server.

-> Should I have to make any configuration settings in the server.
-> Should I change any values in the server.
-> Is there any way to properly maintain the server.

View 3 Replies View Related

Forms :: Export Forms Data Into Excel Sheet - Client-ole2 Not Working?

May 28, 2010

I want to export forms data into Excel sheetfor that i am using Client_Ole2.I have attached Webutil object library and Pl/Sql libraryStill I can not export data from Form to Excel sheet

View 7 Replies View Related

Server Administration :: OS Authentication Is Not Working In 11G?

Apr 20, 2011

OS authentication is not working

Does 11g need any different setting?

Following are the settings

1)

SQL> show parameter os_a

NAME TYPE VALUE
------------------------------------ ----------- --------------
os_authent_prefix string OPS$
remote_os_authent boolean FALSE

2) sqlnet.ora has following setting

SQLNET.AUTHENTICATION_SERVICES = (NTS)

3) I have created user like following

sql> create user OPS$CLASS
2 identified externally
3 default tablespace user_data
4 temporary tablespace temporary_data
5 profile clas_prof
6 account unlock;

user created.

sql> grant connect to OPS$CLASS;

Grant succeeded.

With the same settings it successfully connects from my 9i client to the 9i database
(DB01, below)

C:Documents and SettingsCLASS_user>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 20 10:18:58 2011

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: /@DB01

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

However it fails to connect to 11G database (DB02, below)

C:Documents and SettingsCLASS_user>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 20 10:19:29 2011

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: /@DB02
ERROR:
ORA-01017: invalid username/password; logon denied

View 6 Replies View Related

Listener File From A Working Server

May 10, 2013

i have a software...i installed it and configured it to the database now i copied the listener file from a working server to this both have same name and configuration and databases with same port number.

but when i try to log in it throws a error

ORA-12154 TNS COULD NOT RESOLVE THE CONNECT IDRNTIFIER SPECIFIED

I checked my listener tns.ora files and all are correct but still i cant connect.

View 1 Replies View Related

ORA-00932 - Sample Code Working Fine In 10g And Not Working Now In 11g

Apr 1, 2013

Below is the sample code working fine in 10g and not working now in 11g.

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS
import java.sql.SQLData;
import java.sql.SQLException;
import java.sql.SQLInput;
import java.sql.SQLOutput;
import java.util.List;
[code]....

we got the below error: ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class

Current Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit and the version we are upgrading is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

View 3 Replies View Related

Forms :: GET_FILE_NAME Is Not Working

Aug 6, 2013

I am developing a form using Forms [32 Bit] Version 6.0.8.11.3 (Production). In my custom form I have given a Push_Button and my idea is to invoke a File open diaglog box when I hit the button.

So, i wrote the below code under 'when-button pressed ' triger. But, the button is not invoking the File Open diaglog box in TEST environment.

=====
DECLARE
XXFILENAME VARCHAR2(50);
BEGIN
XXFILENAME := get_file_name('C:', NULL,
file_filter=> 'JPEG Image (*.JPG,*.JPEG,*.JPE,*.JFIF)|*.JPG|Bitmap Image (*.bmp)|*.bmp|GIF Image (*.GIF)|*.GIF|TIFF Files (*.tif)|*.tif|All Files (*.*)|*.*|');
END;

View 7 Replies View Related

Forms :: Progress Bar Not Working

Dec 11, 2011

i have this procedure in my form to make some checks on employee data:

Procedure Pu_Check_Emp_Positions_Prc Is
Cursor vc_get_users_data_case1 Is
Select A.User_No, A.User_Responsility, A.User_Position, B.User_Status
From Import_Emp_Positions_Dtl A,
Shows_Users B
Where A.User_No = B.User_No
And (Substr(A.User_Position, 1, 1) = 'R' Or Substr(A.User_Position, 1, 1) = 'r')
And A.User_Responsility Is Not Null
And B.User_Status In (2, 3, 4, 7, 8);
--And A.User_No = 'XSER0001';
[code]....

i need to run this progress bar and finished when the procedure finish.

View 7 Replies View Related

Forms :: Go-item Not Working?

Feb 1, 2012

I hab a button:

flag:=show_lov('lov16');
if :block.cliente_no is not null then
go_block('clientes');
execute_query;
go_item('block.codigo');
end if;

it calls a LOV and return a value to :block.cliente_no, then execute a query in block clientes, but cursor doesn`t goes to block.codigo it remains in the button ! Why doesn`t works ? Note: if I insert a message before line go_item('block.codigo'); cursor goes to 'block.codigo' (message('hallo');

View 3 Replies View Related

Forms :: Enable_list_lamp Is Not Working

Oct 2, 2013

i follow the below steps but the calendar lov and button are not shown

1- Go to property pallet of an item set "Subclass Information" TEXT_ITEM_DATE
2- In the field properties, under LOV, set Enable List lamp to Yes
3- Set Validate from List to No
4- Create a Trigger "key-list-val" at item level, code the following: calendar.show
5- Compile it and save

View 11 Replies View Related

Forms :: Go Block Not Working?

Sep 18, 2012

In a Entry Screen I Require to Check the Value is Changed or not in a Block (A).

If the Value is Changed then Require to done some validation in another block (B) for take the final entry date and their after going to another Block (C), here user require to enter Some data in it.

I am Using the When Timer Expired in the Block (A) for Check the Value and Going Another block, it working till going another after complete the entry Block (C) I have using a Button for move to Main Block (A), but it not going to the consign block and then i put the Message in it, the message is showing, but not going to the block.

View 1 Replies View Related

Forms :: FMB - Populate Lov Is Not Working?

Oct 14, 2010

.fmb file why this populate lov is not working

View 9 Replies View Related

Data Guard :: Check RFS Server Is Working

Oct 27, 2007

Is RFS an background process.How do I check if its working or not.Can I stop and start RFS.

View 14 Replies View Related

Server Utilities :: DECODE Not Working While Using With SQL Loader?

Sep 18, 2010

I had a requirement of loading flatfile into staging table using SQL Loader, One of the columns in the the Flat file is having values FALSE or TRUE and my requirement is that I load 0 for FALSE and 1 for TRUE which can be achieved by simple DECODE function...I did use decode and tried to load several times but did not work.

INFILE 'sql_4ODS.txt'
BADFILE 'SQL_4ODS.badtxt'
APPEND
INTO TABLE members
FIELDS TERMINATED BY "|"

[code]...

I did try putting a trim as well as SUBSTR but did not work....the cloumn just doent get any values in the output (just null or say free space)

View 5 Replies View Related

Server Administration :: CPU Patch Not Working Properly?

Feb 10, 2009

I applied the Jan 09 CPU to my database this past Saturday and now my daily schema export is not running properly:

With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport done in WE8MSWIN1252 character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms

[code]...

View 8 Replies View Related

Server Administration :: Updating Statistics - Not Working?

Jul 4, 2010

if there are any problems with updating statistics? My manager told me that they had big performance issue when they updated the statistics of whole database. Is this a rare case?

I know the advantages of updating statistics,but are there any dis-advantages?

View 2 Replies View Related

Forms :: Mouse Triggers Not Working?

Sep 5, 2010

why when-mouse move,up,enter,leave are not working in oracle forms 10g except when-mouse-click and when-mouse-doubleclick on any items.

what i need to do to execute this triggers..

View 3 Replies View Related

Forms :: Webutil Not Working In Solaris

May 9, 2011

i have insert image using webutil (oracle forms 10g) to database in windows o.s. it was successful. but when i have tried it in solaris o.s. . It is not working in linux how to do it in solaris o.s. when i am clicking on the browse button it is showing pl/sql error how to solve it.

View 3 Replies View Related

Forms :: Navigation Not Working Using Go Item?

Jan 9, 2012

'm using go_item to open the canvas but the cursor doesnt want to focus on the item. I have to mouse click the item before I can enter any data or tab through it.

View 16 Replies View Related

Forms :: Why Function Keys Are Not Working In 9i

Dec 27, 2012

why function keys are not working in forms9i?

Like whenever I press F7 for query or F8 to fetch records or F10 to save records they are not functioning.

View 2 Replies View Related

Forms :: List Item Not Working In 10g?

Jan 28, 2011

I want to dynamically populate a list item such that the item list should show the name and its value should enter in the background.

I have tried by writing a query in record group, populated it. the list is showing the name in a list item which is not database item. On this List I have written a trigger which is fetching the value to another text item. It is working well but I am not convinced by this method.

for reference, i want if customer select A then list should show balanced and its value is 1when B then list should show lag,lead,advanced... values 2,3,4,.. respectively.

View 3 Replies View Related

Forms :: Oracle Designer Not Working?

Aug 20, 2010

whenever i double-click on the Canvass node of Forms builder, it displays the "Working..." status on the lower left corner, then after a minute or so, the following message appears:
--
"Oracle Forms Designer has encountered a problem and needs to close. We are sorry for the inconvenience.If you where in the middle of something, the information you were working on might be lost.

Send Error Report / Don't Send"
--
after clicking on the Don't Send button, the builder will close down. i just installed oracle 10g (10.2.0.1.0) database and 6i developer which i downloaded from oracle website.

View 2 Replies View Related

PL/SQL :: To_char Not Working / (||) Is Working With Join Query

Mar 22, 2013

I have two tables : oa_membership_dtl(in this created_by field is varchar2(200 byte) ,oa_partner_usr_dtl(in this table partner_userid is number(8,0) i need to do join on above fields.

I am using following two queries:

select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on to_char(partner_user.partner_userid,'9999')=membership.created_by
select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on rtrim(ltrim(partner_user.partner_userid||' '))=rtrim(ltrim(membership.created_by))

by using first data is not fetched but 2nd is working fine , i am getting the matched records using 2nd query.

whats the diff between to_char and || symbol?

View 1 Replies View Related

Server Administration :: Auditing Lob Column Changes When Working With Dbms_lob

Oct 26, 2010

It seems that dml trigger doesn't fire when lob field is being updated using dbms_lob package. As it stated in Oracle documentation:

Quote:Using OCI functions or the DBMS_LOB package to update LOB values or LOB attributes of object columns does not cause Oracle to fire triggers defined on the table containing the columns or the attributes.

I need to know that table was updated (or is about to be updated), how can I do that in case it is lob field that is being updated?

View 1 Replies View Related

Server Utilities :: SQL Loader Control File Is Not Working

Jan 28, 2011

The reason "why sql loader's CONTROL FILE is not working, if that location has space in between"

E.g. - C:practice for sqlloadercontrol1.ctl

But it works if we remove the space in between the path as below:

E.g. - C:practice_for_sqlloadercontrol1.ctl

View 3 Replies View Related

Forms :: Tree Hierarchy - Not Working Properly?

Apr 8, 2009

i have created a tree hierarchy....when the user clicks on any node,that particular form will open....But there is some problem...i click on form A,it opens.,...then i exit that form via a exit button on the toolbar....and then I click on form B on the tree....but first the form A only opens...and then again i exit form A, then form B will open..

i have written the following code in when_tree_node_selected trigger :

if condition then
call_form(path,no_hide,do_replace);

View 3 Replies View Related

Forms :: Internet Explorer 8 Not Working As Browser For 10g?

Mar 1, 2010

For all my client machine Internet Explorer 8 is not working. Internet Explorer 7 is working fine . For a machine with Internet Explorer 8 after Installing Mozilla Firefox it's working under Mozilla Firefox Browser well.

View 3 Replies View Related

Forms :: List-item Selection Not Working?

Oct 3, 2012

i am facing a problem in functionality of a form as there are different search parameters:
date from: text item-->mandatory
date to: text item---->mandatory
house type: list item-->optional
form_status: list item->optional
order by: list item---->optinal

untill i don't select house type by list item everything is working fine and gives desired result, even with house type if i select any house type result is fine but as i select last list item of house type which is null as i want result without house type then it gives no any data as data is present in database.

for example:
date from: 20-05-2009
date to: 21-05-2009

with these two i got the correct result, then i select
house type: 3

i got the correct result and when i change list item to any value like: 1,2,3.....it is working fine but as i want result without house type by selecting the null value in list item as:
date from: 20-05-2009
date to: 21-05-2009

it is not picking any data from database. but the same search criteria in 1st case as i described above giving result.
declare
qry varchar2(5000);
n number;
alert number;

[code]...

View 5 Replies View Related

Forms :: Oracle Translation Builder Not Working?

Feb 9, 2013

i want to use oracle translation builder to translate forms and reports from English into Arabic i run run the script SQLBLD and create new db connection an finally create a new project when am trying to import module i got the error NX-00201

View 3 Replies View Related







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