Forms :: How To Set Environment Variable

May 16, 2010

how to set environment variable in oracle application.

View 1 Replies


ADVERTISEMENT

Windows :: Value For PATH Environment Variable?

Jan 23, 2013

what value exactly I need to give for the PATH environment variable in oracle 11g running on windows xp?

View 15 Replies View Related

SQL & PL/SQL :: How To Set Environment Variable Inside Procedure

Nov 24, 2010

I am calling a select query inside a procedure but i need to set environment variable 'set linesize 200' inside that procedure but i am not able to create the procedure due to some error. I am attaching the procedure query here with:

before the select query i need to insert this environment variable : "set linesize 200"

create or replace
procedure TABLESPACE_USAGE
is
l_mailhost VARCHAR2(64) := 'ip address';
l_from VARCHAR2(64) := 'email id';
l_subject VARCHAR2(64) := 'TABLESPACE_USAGE1';
l_to VARCHAR2(128) := 'email id';
[code]......

View 2 Replies View Related

Windows :: How To Set SQLPath In Environment Variable

Aug 11, 2011

When I run the command "host set sqlpath" I get the following message "Environment variable sqlpath not defined",how I can set my oracle sqlpath

SQL> host set sqlpath
Environment variable sqlpath not defined.

how can I set an sqlpath in enviroment variable?

View 7 Replies View Related

Error / Environment Variable Oracle_sid Not Defined

Aug 5, 2010

I am getting an above errors while starting the emctl start dbconsole..

View 9 Replies View Related

Installation :: Environment Variable Path Failed In Oracle 11g?

Dec 13, 2012

i am reinstalling oracel 11g in my window 7 64 bit machine after i uninstalled it. however, i got an issue that is environment variable path failed in the installation process. this didn't happen when i firstly successfully installed oracle.

View 7 Replies View Related

Server Administration :: (Upg 9208-1020) ORA-07217 - Environment Variable Cannot Be Evaluated?

Nov 15, 2011

After settig the proper environment whenever I issue startup upgrade at the SQL*Plus prompt i get the following error.

ORA-07217: sltln: environment variable cannot be evaluated.

I have 3 other databases on the same machine that I successfully upgraded without encoutering this error.

View 10 Replies View Related

Backup & Recovery :: Moving From One Windows Environment To Another Linux Environment?

Jun 19, 2012

I'm trying to move my backup sets from windows database environment, to OEL 5.7 environment on another server.

I've found a manual [URL] by which I am trying to do it.I took backup sets from last night's backup using RMAN,and the current parameter(initSID.ora) file from the running live database.Now i need to configure control files in the pfile accordingly.

1. can i take current control files from the running system, to restore and recover backup sets from last night, to the state the database was at backup time?

2. how can i find out if control files are backed up and know by RMAN? "list backup completed after '2012-JUN-19';" >> gives me Archive redo logs, datafiles, but don't see the control files(or don't reconize them).

View 15 Replies View Related

How To Set Apache Environment Variables From Forms

Dec 27, 2012

We have an application, where we invoke a URL pointing to a folder on the Application Server, so that users can download files from the same.

There is user authentication provided for the URL.

Example :

Our application ABC (example) which is built with Oracle Forms 10g, hosted on Application server (itxxx123) inovkes a module GEN9999 which on pressing a button calls a URL which is open in the Internet Explorer browser.

If the URL has been called from the Forms or the Application (ABC), then it should be allowed.

If the URL is called standalone, by Opening IE Browser and invoking the URL, this should not be allowed.

However, there have been security concerns raised during Audit, saying that users can access the URL directly from the Browser instead of the Application. Also the URL is saved the Browser history, so even if the user is no longer working in the Application Team, and has moved out of the team, then the ex-user can still access the URL and view and download files.

Is there any way to restrict access to the URL such that is only accessible when it is called from the Application, and that access is restricted when directly called from the Browser.

I have seen that environment variables in httpd.conf may be usable for the above. However, not sure how to use them from Oracle Forms.

View 1 Replies View Related

Forms :: Reports In Unix Environment

Mar 23, 2010

Below is my code for calling a report from form in windows environment. I want to use the same report to be called from Unix environment . When m using application server tbanner@.... instead of 'repsrv@ahad-pc' is throwing error its in UNIX environment

REP-51002: Bind to Reports Server tbannerdb.kfupm.edu.sa failed

Declare
v_show_documentVARCHAR2 (2000) := '/reports/rwservlet?';
v_connectVARCHAR2 (200) := 'userid=abdulahad/inshalla@test';
v_report_serverVARCHAR2 (30) := 'repsrv@ahad-pc';
v_report_nameVARCHAR2(100) := 'test3.rdf';
[code].......

View 6 Replies View Related

Forms :: Dynamic IF Condition Evaluation In 9i Environment

Apr 6, 2005

I'm using forms 9i. Let's say I have a Block in the form B1. It has two items I1 and I2. I have a table called T1 that has a column say C1. The data in the only record in T1 is 'NAME_IN(''B1.I1'') = 1 OR NAME_IN(''B1.I2'') = 2'..In forms I need to execute the following at POST-QUERY trigger of the block:-

DECLARE
VAR1 VARCHAR2(1000);
BEGIN
SELECT C1
INTO VAR1
FROM T1;
[code]....

As you could see that the IF statement is wrong. But I get the condition (for IF condition) as a string value from some database table.

View 9 Replies View Related

Forms :: FRM-18103 / Failed To Initialize Development Environment

May 27, 2010

Error - FRM-18103:Failed to initialize the Development Environment I have installed Oracle 11g and Oracle Developer Suite 10g in separate oracle homes.

When I try to open Oracle form builder I am receiving 'FRM-18103:Failed to initialize the Development Environment' error.

View 5 Replies View Related

Forms :: Client-server Environment - Unable To Connect To Destination

Nov 29, 2010

i am using client-server environment without using a domain.On One computer i have installed Oracle 8.0.5 and developer 2000. and on client side i have installed form 6i. i have made a service (star) in Tnsnames.ora in client side.

star.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROtoCOL = TCP)
(Host = server)
(Port = 1521)
)
)
(connect_DATA = (SID = ORCL)
)
)
--------------------------------------------
it gives me error:

ORA-12203:TNS :unable to connect to destination

View 6 Replies View Related

Forms :: Set The Value Of Variable With Parameter

Nov 25, 2012

how to set the value of variable with parameter like below?

example :

I want the value of these variables define like below
var1 := 1;
var2 := 2;
var3 := 3;

[Code]....

error of the syntax is ... bad bind variable 'var' how to interpret variable var1 from var||j.

View 3 Replies View Related

Forms :: How To Get Visual Attribute Name Into A Variable

Mar 2, 2012

how to get visual attribute name into a variable ??I have used the below code....

s_v:=get_item_property('slot1',visual_attribute);

but i am unable to get the name of the visual_attribute..

View 9 Replies View Related

Forms :: Bad Bind Variable Error?

Jun 29, 2013

Whenever I am compiling the code, following error is coming.

BLOCK: WHEN-NEW-FORM-INSTANCE(Form),5 errors
Error 49 at line 42, column 1
bad bind variable 'tool.dsp_heading'
Error 49 at line 42, column 1

[code]...

View 6 Replies View Related

Forms :: Error 49 Bad Bind Variable?

Dec 14, 2011

i am getting this error when compiling (error 49 bad bind variable) is there anything wrong in this
(

declare
total_rec number(2);
begin
:new_id:=null; :new_sal:=null;

[code]...

the code in the add-new command when_button_pressed trigger am adding employee to the employee table by this form

View 1 Replies View Related

Forms :: How To Sent Global Variable Between Two Forms In 10g

May 12, 2011

How to sent Global variable between two forms in oracle form 10g ? ( with web.show_document )

View 3 Replies View Related

Forms :: How To Share PL/SQL Variable Between 2 Forms

Nov 20, 2010

I create 2 forms

form 1: I used the Departments table to create this form

in form-level trigger : When-New-Form-Instance

go_block('departments');
execute_query;

there is a control block with name (CTRL)

there is Exit button with trigger When-Button-Pressed exit_form

there is a text item to print the department_id that i select this is for confirmation. I populate this item by (department no) button When-Button-Pressed

my_data.department := :departments.department_id;
:CTRL.TEXT_ITEM8:= :departments.department_id;

Now this part has the global shared pl/sql variable when i press in the button POPULATE_AND_SEND with a trigger When-Button-Pressed

my_data.department := :departments.department_id;
OPEN_FORM('c:Shared_PLSQL_Variablesemployees.fmx',ACTIVATE,NO_SESSION,SHARE_LIBRARY_DATA);

form 2 in this form i used employees table it will display the data that is content in the department selected from the first form it only has form-level trigger When-New-Form-Instance

IF my_data.department IS NOT NULL THEN
SET_BLOCK_PROPERTY('employees',DEFAULT_WHERE,'department_id='||to_char(my_data.department));
:CTRL.TEXT_ITEM8:= my_data.department;
GO_BLOCK('employees');
EXECUTE_QUERY;
END IF;

this is the code in .pll file that i attached in Attached Libraries

PACKAGE my_data IS
department number;
END;

when I run this forms and press in (DEPARTMENT NO) button it's not display any thing in the text item I received this error check the link.

same error when i press in POPULATE AND SEND button to open the other window and execute query.

View 11 Replies View Related

Forms :: Executing Procedure Based On Variable Name

Apr 1, 2011

I need to execute a procedure based on a value in a form. So the procedure name will be changing for value selected in a list.

I need to know a method where i could store the procedure name in a table and when ever i select a value from the list, the respective procedure needs to be executed.

View 1 Replies View Related

Forms :: Pass Global Variable To DB Trigger?

Dec 6, 2011

how can i pass global variable from form to db trigger ?

i have this trigger:

Create Or Replace Drop Trigger Access_Group_Category_Priv_Trg
After Delete Or Insert Or Update
On Scott.Access_Group_Category_Priv

[Code].....

View 4 Replies View Related

Forms :: Define Global Variable In Oracle 6i

Aug 12, 2010

I want to define global variable in oracle form 6i....so this variable may i used anywhere in project...but i don't know where exactly global variable defined?

View 7 Replies View Related

Forms :: Variable Can't Hold 4000 Characters

Dec 22, 2011

I have error message when running duplicate : FRM-21011: PL/SQL unhandled exception ORA-06502..I'm trying to hold 4000 characters in a variable like what do below:

if s_str is NULL then
s_str := eachcol.column_name||'{{'||
name_in(name_in('system.cursor_block')||'.'||eachcol.column_name)||'{{';
else
s_str := s_str||eachcol.column_name||'{{'||
name_in(name_in('system.cursor_block')||'.'||eachcol.column_name)||'{{';
end if;

It's simple variable to hold value but still can't get by large string though.

View 1 Replies View Related

Forms :: ORA-01036 - Illegal Variable Name / Number

May 30, 2012

I have developed a form which is running fine most of the time,

but some time it gives error

unable to insert record and if we see detail it shows

ORA-01036: illegal variable name/number

error.jpg is attached. if there is some problem, it should not pass any entry and if there is no problem then why it gives error of illegal variable?

View 3 Replies View Related

Forms :: Frm-40815 Error Variable Does Not Exist

Apr 6, 2011

I am using Global Variables to store the data from the form variables and once again restore it in the form when User ID is entered.

For this I write the code in Pre-commit trigger
:global.gzaoffe_nofday := :gzaoffe.gzaoffe_nofday;
:global.gzaoffe_time_period := :gzaoffe.gzaoffe_time_period;
:global.gzaoffe_time_from := :gzaoffe.gzaoffe_time_from;
:global.gzaoffe_time_to := :gzaoffe.gzaoffe_time_to;
:global.gzaoffe_date_from := :gzaoffe.gzaoffe_date_from;
:global.gzaoffe_date_to := :gzaoffe.gzaoffe_date_to;
:global.gzaoffe_official_reason := :gzaoffe.gzaoffe_official_reason;

Then I write the code in KEY-NEXT-ITEM trigger of gzaoffe.user_id

:gzaoffe.gzaoffe_nofday := :global.gzaoffe_nofday;
:gzaoffe.gzaoffe_time_period := :global.gzaoffe_time_period;
:gzaoffe.gzaoffe_time_from := :global.gzaoffe_time_from;
:gzaoffe.gzaoffe_time_to := :global.gzaoffe_time_to;
:gzaoffe.gzaoffe_date_from := :global.gzaoffe_date_from;
:gzaoffe.gzaoffe_date_to := :global.gzaoffe_date_to;
:gzaoffe.gzaoffe_official_reason := :global.gzaoffe_official_reason;

Form is compiling successfully. But when I enter the User ID It is showing the error FRM-40815 Variable GLOBAL.GZAOFFE_NOFDAY does not exist. Like this it is showing for all global variables.

View 2 Replies View Related

Forms :: ORA-01007 - Variable Not In Select List

May 9, 2013

I wrote the following

DECLARE

VISCONNECTED BOOLEAN;
VCONEXAO EXEC_SQL.CONNTYPE;
VARQUIVO_SAIDA TEXT_IO.FILE_TYPE;
VCURSOR EXEC_SQL.CURSTYPE;
VCOLUMNVALUE VARCHAR2(2000);
VSTATUS PLS_INTEGER;

[code].....

But, on line "VSTATUS := EXEC_SQL.EXECUTE(VCURSOR);" i get the error (ORA-01007 - VARIABLE NOT IN SELECT LIST). Whats is wrong?

View 8 Replies View Related

Forms :: Error During Compilation - Bad Bind Variable

Jul 28, 2008

I have developed a form based on a database of books. The information displayed during run time is Sr No, Book name,Author, Copies, Description and Image(of the book)

I have written a PL/SQL code to display the image of the respective book for every new record. E.g Book1 should display image1, book2 displays image2 and so on. This should happen at runtime. The code is:

declare
gif_image varchar2(80):='c:ProjectBooks';
photo_filename varchar2(80);
begin
photo_filename := gif_image||lower(:books.sr_no)||'.gif';
[code].......

The error i get during compilation is

Error 49 at Line 5, column 37
bad bind variable 'books.sr_no'

View 4 Replies View Related

Forms :: How To Parse Paramlist Type Variable

Mar 22, 2010

how to parse paramlist type variable to get names of the fields and their values in the paramlist?

View 1 Replies View Related

Forms :: Session Variable Values Overwritten Between Transactions?

May 23, 2011

There are 2 people on separate machines each executing a transaction through the same form, processed through a when-button-pressed trigger.The first session processed correctly. For the second user, the session seems to have picked up the non-PACKAGE variables of the first session in what was passed through to the data base. Values associated with the 2nd session's PACKAGE-based types appear to have passed through correctly.

Hence, the second user's transaction processed with a combination of values from the two sessions, with the second user's PACKAGE-based variables merged with the first user's non-PACKAGE variables. There is no use of context variables. There are some global values, but none of them are used in this trigger.The values in question, that appear to have passed from the first session to the second, are based on contextual LOV selection: after selecting a transaction type, users are prompted to select from a LoV specific to that type. Value property set "Validate from List=>Yes".

The 2nd session's PACKAGE-based values do not correlate to the non-PACKAGE values, leading us to conclude that the latter values somehow came through from the first session. We are running IAS 10g R2 on Oracle 10gR2 (10.2.0.3).Each user session is created as user logs into the application and hence logically there should not be any overlap between sessions of different users concurrently.

I did have a look at the code and predict nothin wrong with the source code since the system has been in use for a few years now and only occurred a couple of times in last few months. Also one more noticeable thing is that the issue is not reproducible. I would believe somethin goin wrong in the middle tear or with the session management. Are there any known issues in session management in the Forms server Or something?

View 5 Replies View Related

Forms :: How To Declare Global Variable And Call Same In Other Form

Oct 6, 2008

I want to call a value from one from to another form in d2k forms 4.5. I think this can be done only by declaring a global variable. I don't know how to declare global variable and also calling the same in other forms.

View 14 Replies View Related







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