Forms :: Possible To Alter A Session Within Oracle Form

Sep 3, 2010

Is it possible to alter a session within Oracle forms as I get the following error when trying to compile the following block.

BEGIN
EXECUTE IMMEDIATE ( 'alter session set nls_date_format = 'DD-MON-YYYY''');
END;

Error: Encountered the symbol "IMMEDIATE" when expecting one of the following

The basic requirement is to validate a date field on the form against the current system date, but as the form is in format DD-MON-YYYY and the Database on M/D/YYYY I am struggling to compare dates successfully.

View 5 Replies


ADVERTISEMENT

SQL & PL/SQL :: Difference Between Alter Session And Alter System

Jun 19, 2013

What is the difference between alter session and alter system?

View 2 Replies View Related

Alter Session On NLS_DATE_FORMAT Being Ignored

Feb 24, 2011

I'm issuing an alter session setting NLS_DATE_FORMAT in a C batch process right after the connection takes place. The format I specify is YYYYMMDDHH24MISS, this is the format used all over the process. In my development environment this works perfectly, but I've had problems in other environments.

CASE A development environment: The process works fine, $NLS_LANG and $NLS_DATE_FORMAT environment variables are not set.

CASE B Test envirnonment 1: The process failed.$NLS_LANG=American_America.WE8ISO8859P1 $NLS_DATE_FORMAT environment variable is not set.For some reason the $NLS_LANG variable seems to have more weight than the alter session command.. why? The process works fine after setting $NLS_DATE_FORMAT to the desired format.

CASE C Test envirnonment 2: The process failed. $NLS_LANG and $NLS_DATE_FORMAT environment variables are not set. Can't get it to work here. why?

View 1 Replies View Related

SQL & PL/SQL :: Alter Session Number Format?

Dec 20, 2010

how to change the default format of a number value using alter session statement?

I've a problem when I show a value like this "0.123456": the select statement returns ".123456". Is there any way to force a zero value before the character separator?

View 11 Replies View Related

PL/SQL :: Alter Session Query On Linux?

Nov 1, 2013

I was trying to execute below query inside a sql script which is called from a shell script on linux environment.  EXECUTE IMMEDIATE 'alter session set events ''10176 trace name context forever'' ';   

This thing works at our test environment.  But giving error "SP2-0670: Internal number conversion failed" when tried on live(production) environment. What could be the reason? I found another way of writing such queries on net as follows, will it be useful? EXECUTE IMMEDIATE q'|alter session set events '10176 trace name context forever'|

View 1 Replies View Related

PL/SQL :: Alter Session In Select Statement?

Oct 15, 2012

I'm using Oracle SQL Developer and querying on date fields. I use this "alter session" statement to set my default date time format to get my datetime values. My question is, is there a way I can incorporate the following statement into my "select" query so that Crystal can read it? I use the statement below before my select statement to query datetime differences. Problem is, Crystal doesn't like the statement below.

Using TO_CHAR( ) and formatting my date fields that way doesn't work when I have to take the difference between date fields to the minute/second level. That's why I use the alter session command below, but I cannot seem to incorporate it with my select statement as a Crystal data source.

alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS'

View 14 Replies View Related

PL/SQL :: Cannot Create Table After Change Schema With ALTER SESSION

Sep 1, 2012

SQL> ALTER SESSION SET CURRENT_SCHEMA = CLA_T3;

Session altered.
SQL> select sys_context('USERENV','SESSION_USER') current_user,
2 sys_context('USERENV','SESSION_SCHEMA') current_schema
3 from dual
4 ;

CURRENT_USER
--------------------------------------------------------------------------------
CURRENT_SCHEMA
--------------------------------------------------------------------------------
CSR_ETL
CLA_T3

SQL> set linesize 300;
SQL> /

CURRENT_USER
----------------------------------------------------------------------------------------------------
CURRENT_SCHEMA
----------------------------------------------------------------------------------------------------
CSR_ETL
CLA_T3

SQL> create table cla_t3.test (r number, b char(2));
create table cla_t3.test (r number, b char(2))
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> create table test (r number, b char(2));
create table test (r number, b char(2))
*
ERROR at line 1:
ORA-01031: insufficient privileges

After Setting current schema to 'CLA_T3', I am unable to create table in cla_t3 schema.

View 5 Replies View Related

Reports & Discoverer :: ORA-02248 - Invalid Option For ALTER SESSION

Aug 25, 2013

I got this error when try to connect to the database using discover administrator or user edition

ora - 02248 : invalid option for ALTER SESSION

i can connect to the database with sqlplus with no problem.

View 4 Replies View Related

Client Tools :: Alter Session Of Connections In JBoss Connection Pool

Aug 23, 2012

We have a Data Source with min_pool_size (10) and max_pool_size (20). A Data Source is by default a connection pool. By starting a transaction we are retrieving a connection from the pool (i.e., opening it to retrieve data, perform queries, inserts and updates). Our application server is JBoss. An application workflow uses many transactions to build a product. The same connection is not used by the application for the entire workflow; but, it uses and returns them to the connection pool. We do not use Java syntax like "rs.close():"... this is performed by iBATIS.

On the Linux side when we execute a "ps" command (ps -elf|grep -i ora) we see all the Oracle processes. A further refinement of that command (ps -elf|grep -i local=no)shows a list of the "waiting" connections in the connection pool. The DB may be queried with the following syntax:

SELECT schemaname, sid, serial# FROM gv$session where schemaname = 'APP_USER' order by SID;

A list of connected sid and serial numbers is returned, identifying which connections are in use. From here we are able to force the connection to trace by executing the following:

exec dbms_monitor.session_trace_enable(249, 6595, TRUE, FALSE); ! 249 and 6595 being SID and Serial# from query above

There should be no need to execute the inverse, since the connection is returned to the pool when the transaction is committed or rolled back.

exec dbms_monitor.session_trace_disable(249, 6595);

We are trying to trace in order to use the Quest Benchmark Factory. Their instructions request the following syntax be applied to each session:

alter session set events '10046 trace name context forever, level 4';

and again, the inverse should not be necessary.

alter session set events '10046 trace name context off'

When it became too cumbersome to alter each session as it appeared, we issued an "alter system" to monitor (trace) everything. The trace files filled the disk, and four hours of testing was stopped two hours in. Doing a system level trace is probably not a good idea.

My first inclination was to create a post-logon trigger to set trace in the session; however, these connections, coming from an JBoss connection pool, do not logon each time, and I presume that they are not all the "same session".

We opened a support ticket with Quest last Friday and do not have an answer yet. This was the third ticket with them, the first to get Benchmark Factory installed (the original installer did not work). The second ticket was to setting up a shared directory on Linux with a folder on Windows, a setup configuration required by their tool. The third ticket to address this issue.

They needed to contact "the developers" to answer the last two questions. Their latest suggestion is to fix ticket two so we "won't need to trace" anything. How do I set trace in these connections?

View 6 Replies View Related

SQL & PL/SQL :: Restricting Form To Only One Session?

Feb 6, 2012

1. i want that if a form is opened in one user session. it will not be available to other users.

2. if a user executes a procedure. it should not be available to other users to execute until the first execution completes.

View 12 Replies View Related

Forms :: Killing Inactive Session Through Oracle Application Server

Mar 5, 2013

I am trying use host command in Oracle forms. I get the process id as input from the user and on clicking ok the form should kill the session related to process id.

PS: Users will be entering only frmweb.exe process id which are inactive.

cmd := 'CMD /C taskkill /F /FI /pid 'process which is got as input' /IM frmweb.exe'; host(cmd)I also tried by writing the above command into a .bat file in application server.When trying to execute the bat file it din work. But when tryin to run the bat file by double clicking in Application server the session was killed.

On executing the above I am unable to kill the process. I would also like to know whether the host command was successful or not. Orakill and alter session are working but I don want to use it.

View 2 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

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

View 9 Replies View Related

Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black

Sep 23, 2011

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

View 5 Replies View Related

Forms :: Migration Of Oracle Form 10g To 6i?

Apr 19, 2011

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

Forms :: Matrix Form In Oracle

May 20, 2013

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

View 1 Replies View Related

Forms :: Why Other Browser Cannot Run Oracle Form Without IE

Oct 9, 2012

Why Other Browser cannot run oracle forms without IE.

i want to use other browser for oracle form like firefox,google chrome etc not IE.

View 11 Replies View Related

Forms :: How To Convert Oracle 10g Form To 6i

Oct 24, 2013

How to convert Oracle 10g Forms to Oracle 6i Forms ?

View 2 Replies View Related

Forms :: Oracle Form Entry?

Feb 25, 2010

i am new to oracle form , i am using orcale 10g forms, i have following requirements.

1-I have a Data Block names Hes_Modules which is connected to a table HES_MODULES having following fields (modid,moddescr).

i want when form open it should show all enteries in table, My form conatin 5 fields and scrollbar.After form open it should allow to update and insert the reords in form

View 3 Replies View Related

Forms :: How To Run Oracle Form Server 10g From IPhone

Sep 27, 2013

How to Run Oracle Form Server 10g From IPhone

View 3 Replies View Related

Forms :: Parametrized Cursor In Oracle Form

Dec 7, 2011

I am creating a button , on this button i call a procedure

e.g. excel

on this procedure i call parametrized cursor ...but i give me error i dont know what is this ..my code is like this

Quote:
PROCEDURE excel IS
CURSOR C2(v_link_nm varchar2) is
select alt_loc LOC, alt_inv_no INV_NO, alt_inv_dt INV_DT, alt_amt AMOUNT, alt_rvc2 ALT_RVC,
alt_doc_no DOC_NO, alt_doc_typ DOC_TYP, alt_authid AUTH_ID, alt_authdt AUTH_DT
from v_link_nm
[code]......

when i compiled i get error v_link_nm not defined...

View 1 Replies View Related

Forms :: Create Directory With Oracle Form PL/SQL

Jan 16, 2010

i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g

my problem is when i use this code

trigger WHEN-BUTTON-PRESSED

EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';

IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"

I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');

trigger WHEN-BUTTON-PRESSED

WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');

BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "

How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();

View 9 Replies View Related

Forms :: SQL Server And Oracle In A Single Form

Apr 23, 2011

can I query sql server and oracle in a single form

View 1 Replies View Related

Forms :: Remote Form Debug In Oracle 10g

May 12, 2010

I am trying to debug a remote form ( on AS) in Oracle forms developer 10g . I had done everything as told and attached the port name and number to my local form builder, but debugger window doesn't popup at the time of break point. Also, i don't have any firewall installed on my application server.

View 1 Replies View Related

Forms :: Draw Diagram In Oracle Form?

Jan 27, 2012

I want to draw a diagram in oracle, how do i do?

View 4 Replies View Related

Forms :: Oracle 10g Key Combination To Call Form Trigger

Nov 11, 2009

I need to fire the KEY-DUPREC trigger as I click on the key combination Shift+P therefore; I added the following line of code in the frmweb.res file.

80 : 1 : "Shift+P" : 64 : "Duplicate Record"

It worked iff no error was raised. So, if I have a raise form trigger failure in the KEY-DUPREC trigger, a capital P will appear in the text field that called the trigger.

View 2 Replies View Related

Forms :: Display Image On Oracle Form Through Backend

Dec 17, 2011

I am successfully insert image in DB now...now my task is i want to retrieve this image on my oracle form.

my structure on table like this..

CREATE TABLE temp_image
(
ID NUMBER,
image_filename VARCHAR2(50),
image BLOB
);

i inserted 2 images on that... now i want to retrieve it , how to achieve this.

View 6 Replies View Related

Forms :: How To Send Automated Email From Oracle Form

May 10, 2011

I have to send several reports to various branch via email, I created a branch table in which email of that branch is stored in a column. Now if report is generated for particular branch, its PDF should also be sent via email to that branch, How can this be done on When Button Pressed,

View 1 Replies View Related

Forms :: Tab Page Text Color In Oracle Form?

Jul 19, 2013

i have the two tab pages in canvase...one is for the personal page and other one is the education. now i want to change the color of the text like personal and education.

i want only change the text color of label not the background color...

View 4 Replies View Related

Forms :: Running Form On Oracle Developer Suite 10g

Jul 2, 2011

i am new and developing my first oracle form.but when i am running this form.it's not running,i have installed already jinit.exe setup.Is this necessary internet connection for running forms.port no. is 8890.

View 20 Replies View Related

Forms :: How To Get Current Cursor Position In Oracle 10g Form

Feb 25, 2010

I want to get current mouse cursor position dynamically,what should i do.

View 3 Replies View Related







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