Forms :: Run Adobe Acrobat In Client Side Using 10g
May 10, 2010How i can run adobe acrobat in the client side and maximize it ?
Note: i am using oracle 10g.
ADVERTISEMENT
Forms :: How To Run Client Side Forms
Apr 13, 2010Oracle developer suite 10g i am installing 10 developer in server can you explain me how to run client side forms and report web-throw witch address i tel him to client.
View 2 Replies View RelatedSecurity :: Query Regarding Client Side Wallet
Jul 11, 2012I need few clarifications regarding oracle wallet.
db version: 11.2.0.3.2 (Enterprise Edition)
We have a requirement to run shell scripts calling stored procedures for specific activities, which are run on database server. We do not want to store passwords in shell scripts and decided to use Secure External Password Store for hiding passwords instead of os authentication method. need few clarifications on the below.
1) Currently, we are creating oracle wallet entry on db server and making modifications in sqlnet.ora file accordingly. Is it good to use like this or we should do this only on a client machine?
2) Do we need any licensing to use this option?
3) Any knows issues with using oracle wallet?
4) Can we use orapki for creating oracle wallet instead of mkstore?
5) Any knows issues we face during startup and shutdown of db activities?
Monitoring Script From Client Side (no Access To Server)
Sep 12, 2012We are on oracle 11.2.0.2 on Solaris 10. I dont have acces to the db server but connect to the db from the client side using sqlplus. though I have dba privilege (at oracle level) but no access to db server at os level. I also dont have access to enterprise manager console where such information is available.
I want to set up monitoring so that I can get a mail when the space falls below some threshold like say tablespace is 90% full. Is it possible to get mail from pl/sql script for example?
Oracle 10g On Linux System - ORA 12560 Error On Client Side?
Jan 2, 2011i have installed oracle 10g on linux system. and i am using xp as a client when i use this
cmd>conn scott/tiger@database at client side i receive ora-12560 error
while my database is up and listener and tnsping also working at server side.
Networking And Gateways :: TNS 12537 - Connection Closed On Client Side
Jan 12, 2011I am getting below error while tnsping from client
C:Program FilesMicrosoft Visual Studio 9.0VC>tnsping xpcdev
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-JAN-2011 21:35:03
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.102)(PORT = 1524))) (C
xpcdev)))
TNS-12537: TNS:connection closed
on server side listener is up also I am able to tnsping without any error.
contents from sqlnet.ora
Quote:NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10i
I am getting below error on listener log file
Quote:12-JAN-2011 10:04:56 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
SQL & PL/SQL :: Printing Tables Side By Side
Mar 8, 2012Here i am displaying the multiplication tables by given number...the problem is the tables are displaying one after another...i need to print it by side by side like..
1*1=1 2*1=2 3*1=3
` ` `
` ` `
` ` `
1*10=10 2*10=20 3*10=30
....
the written code is
declare
a number:=1;
[Code]....
PL/SQL :: Updating 2 Tables Side By Side
Apr 4, 2013sqlplus experts,
How do I update Table2(idno) with values of Table1(idno)? By the way there are other columns which i do not want to be touched. This is just to create a match parent-child table test data.
Example:
Table1
idno
===
100
101
102
103
Table2
idno
===
any no
any no
any no
any no
I want all idno values in Table2 to be identical with Table1. It can be any order as long as the value is 1 to 1. I just want it populated for test data purposes.
Application Express :: How To Protect Oracle Application From Code Edit On Client Side Installation
Sep 12, 2013We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,
Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.
Reports & Discoverer :: Exit Adobe Report Oracle Application
Oct 17, 2010Iam using Oracle DB 10g on HP-UX and accessing reports from windows based server as pdf format , After generating report i can save a copy only no exit option from reports and force to exit with shift+f4.
View 4 Replies View RelatedWhere Server Side Procedures Are Stored
Jun 2, 2009Where are the server side procedures are stored? Where are the server side procedures are visible??
View 5 Replies View RelatedUpgrade Server-Side - Oracle DB JVM?
Sep 28, 2012how to upgrade Oracle SERVER jvm version
View 2 Replies View RelatedRAC & Failsafe :: Load Balancing At Server Side
Oct 28, 2010I've configure TAF and Load Banalcing, both of server side some days ago. And now, I find Node 2 is accessed more than node 1. I upload some images here, anything you need to clarify information more, I can give.
Node 2 is often at 40%-55%, some time to 77%.
Node 1 is often 5-12%
Service TAF was configured
Show TAF service by crs
The remote listener
Were I wrong?
SQL & PL/SQL :: TRIM Function - Remove Symbol Only From LEFT Or RIGHT Side
Feb 22, 2011Is there any possibilites to remove the symbol '*' only from LEFT or RIGHT side, instead BOTH the side.
select '>' || trim (both '*' from '***removing stars at both sides***') || '<' "Stars removed" from dual;
Server Administration :: Ora / 1043 User Side Memory Corruption
Nov 20, 2002I'm using Oracle8i, with VB6 as front end When i try to connect Oracle using RDO in VB i get an error message from Oracle It is S1000:Oracle ODBC.ora Ora:1043 User Side Memory Corruption.
View 11 Replies View RelatedApplication Express :: How Vertical Left Side Menus Created
Jun 11, 2012I was keen on creating left side vertical menus instead of using a tab for every page to organize my application better. An example is
[URL].......
I tried creating a list and attaching it to a page. Did not work. Still investigating this. Specifically, what list option that person is using. Not sure, if its really a list or maybe the vertical navigation bar?
Application Express :: Shuttle / How To Reference Selected Items On The Right Side
Sep 13, 2012I have a simple shuttle:
1 Adam
2 Baker
3 Charlie
4 Delta
5 Echo
6 Foxtrot
Select Name D, UserID R from UserTable
The values are stored in a VARCHAR2 field MULTI_USER (for example 1:2:4:6) When I want to get the names back from the selected item, how do I reference the colon-separated items?
For example:
Select Name from UserTable
where UserID in (select MULTI_USER from MULTI_USER where MULTI_USER_ID = 1)
should return:
Adam
Baker
Delta
Foxtrot
Forms :: Export Forms Data Into Excel Sheet - Client-ole2 Not Working?
May 28, 2010I 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 RelatedSQL & PL/SQL :: Union Query Need To Add Extra Dummy Field To One Side Of Query
Dec 8, 2005I have inherited a query that union alls 2 select statements, I added a further field to one of the select statements ( a date field). However I need to add another dummy field to the 2nd select statement so the union query marries up I have tried to do this by simply adding a
select
'date_on'
to add a field called date on populated by 'date_on' (the name of the column in the first query)
however when I run the union query i get the error Ora-01790 expression must have same datatype as corresponding expression.
Forms :: Get Client IP Address When Initializing Forms
Jun 25, 2010How to get the client machine IP in Forms 10g without using webutil? I know the function Webutil_clientinfo.get_ip_address. But Webutil is not working in when new form instance. And I need get client ip address in trigger PRE-FORM.
sys_context('userenv', 'IP_ADDRESS') return address of server, not client.
OR
How to make the trigger WHEN-CUSTOM-ITEM-EVENT in Webutil starts before triggers "WHEN-NEW-FORM-INSTANCE" and "PRE-FORM" ?? To use webutil_ clientinfo.get_ip_address
Forms :: Upgrade Client Forms
May 3, 2010I run into i bug of a 10.2.0.3 database which crashes with older versions of oracle clients (<8.1.7) . I´m running forms 6i patch 4 and want to use e newer client. Is it possible to upgrade the original client?
View 3 Replies View RelatedForms :: How To Get Client IP Address
Feb 15, 2010method to get the ip address of Client machine using oracle forms .
I am using Oracle forms 6i and application server 9i.
Forms :: Get Client IP Address Using 10g Rel.2?
May 2, 2011how i can get Client IP address using Forms 10g Rel.2 and if other useful information i can get, how is it possible? is there any other solution if not using WebUtils ?
View 2 Replies View RelatedForms :: Install Oracle 11g Client
Aug 20, 2012I just installed WEBLOGIC server on linux with oracle forms 11g builder and report builder on the server.
On the client machine , i have probleme to intsall oracle forms 11g , in one of the steps it asks me to enter the absolute location of server weblogic , i enter the location of the weblogic on the server , but it dosent' work. is it mean that i have to install the weblogic on the client machine too!! if not to install forms builder 11g on the client
Forms :: Uploading From Excel Sheet On The Client
Feb 19, 2013I have a form that upload an excel file to the database . I make for in it a browsing button for the uploaded file and take the path (e.g c:upload.xls) when the procedure of upload work. it always search for the path on the application server and thats wrong . I want it to search on the client machine for that path .
PROCEDURE XLS IS
BEGIN
DECLARE
application OLE2.OBJ_TYPE;
workbooks OLE2.OBJ_TYPE;
workbook OLE2.OBJ_TYPE;
worksheets OLE2.OBJ_TYPE;
worksheet OLE2.OBJ_TYPE;
cell OLE2.OBJ_TYPE;
args OLE2.OBJ_TYPE;
[code]........
you see this
filename := :block7.FILE_NAME; (5th line from the begin block)
:block7.FILE_NAME is the path that i said as an example c:upload
That path is on the client machine the form trying to open that path from the application server.
Forms :: How To Run 6i From Server Without Runtime Installation On Client PC
Sep 20, 2013How To Run Forms 6i from Server without Runtime Installation on Client Pc.
View 5 Replies View RelatedForms :: Load Images From Client PC To Form?
Mar 1, 2012how may I load pictures from Client PC into my form (built in Forms 10g) running on Application Server.I've already configured Webutil package.
View 6 Replies View RelatedForms :: Getting Remote Client IP Or Last Proxy That Sent The Request?
Jul 14, 2010I am suffering for a week over a problem in Forms and can not solve it. This problem: [URL] The main part where "reqest.getRemoteAddr()"
View 14 Replies View RelatedClient Tools :: Debugging PL/SQL Web Forms In Toad?
Nov 3, 2008I am doing some work in Banner (the SCT Sungard ERP for educational institutions) and am attempting to use TOAD to debug a PL/SQL web form.
Everything that I've come across thus far indicates that I need to enable debugging, attach the package in TOAD to the external session using Debug > Attach External Session, and then call the web package [URL].
Here are the steps I have followed thus far:
1. Execute the following anonymous block via a SQL window in TOAD to get the debug session ready (I don't have SQL *Plus installed, so I did it from a SQL window instead)
DECLARE
id VARCHAR2(255);
BEGIN
id := DBMS_DEBUG.INITIALIZE('PABLO_TEST_DEBUG');
DBMS_DEBUG.DEBUG_ON;
END;
2. Load the package/procedure I want to debug into a pl/sql window in TOAD and set a breakpoint.
3. Select 'Debug > Attach To External Session', and enter 'PABLO_TEST_DEBUG', which I earlier defined as the debug session id.
At this point Toad just spun its wheels for about five minutes, and then a probe query timeout error was received.
On a subsequent attempt executing the anonymous block simply resulted in the query executing for over 20 minutes, at which point I canceled execution. I'm using TOAD for my development environment, and it's essential that I can get decent debug information.
Given the depth and complexity of the system I am working in (Banner from SCT Sungard), it is incredibly inefficient to have to insert calls to htp.p to find out where the problem is. This has, at times, resulted in a few hours of testing to track down a problem that with a proper debugging environment would be identified almost instantly.
how to enable debugging within TOAD of pl/sql packages/procedures/functions that are called via the web.
Forms :: Download File From Client To Server
Feb 28, 2010When I try to download file from client to server a found the following error./oas/product/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar.
View 8 Replies View Related