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
ADVERTISEMENT
May 12, 2011
How to sent Global variable between two forms in oracle form 10g ? ( with web.show_document )
View 3 Replies
View Related
May 16, 2010
how to set environment variable in oracle application.
View 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Dec 13, 2011
In current form, i use *pll file to pass Global.<variable name> to the form *.fmb
The problem is that if i copy a string of 4000 characters (which i need to) to Global.<variable name>, it will automatically cut a whole chunk to shorter string (less than 1000).
Is there a better way to that Global.<variable name> can hold 4000 characters?
View 1 Replies
View Related
Feb 6, 2010
I have more then one checkbox on my form,I want to get which one is checked on runtime and store it in global variable?
View 6 Replies
View Related
Jul 25, 2010
I have a problem that i have hard coded the username.tablename in each select statement of all forms of my application. Now i want to use a dynamic variable in place of username in each select statement throughout the application. The example is:
select * from scott.emp
and i want to write it as:
select * from variable.emp
But at compilation of the form the compiler should know the above variable name.
I have tried to use following select statement but it does not work.
select user into :global.username from user_users
I think perhaps my problem would be solved with Dynamic SQL Statement but i have no experience by using this statement.
View 4 Replies
View Related
Aug 31, 2011
Till now my company used Share Plex for replication 6 DBs from different location to one server (used for BI operations).
1) Replication in in real time
2) All DBs are Oracle but different versions 9 and 10 .
3) We have horizontal and vertical replication. We replicate just some tables, for some tables just some columns and for some tables just records with some conditions
4) We have different charsets.
5) SharePlex have compare/repair tool to check it DBs are in sync mode
I started to look for Oracle Streams to use it instead of SharePlex. Do you know if it is able to handle that type of replications? Do you know about any Oracle Streams limitation which eliminates it?
View 5 Replies
View Related
Feb 21, 2013
I have an application that it will have over 200 pages. Each page will have a sidebar region with a number of lists, around 8-10 items. The lists references all pages in the app. Then, if I create a new menu list , I have to include this new list in all pages, it's painful. It's posible to have shared regions between pages like the shortcuts for messages in the user interface elements?
In this way, I will create an unique element including all lists that will be shared through all pages. This will greatly facilitate the work!I'm using Apex 4.1.
View 4 Replies
View Related
Aug 26, 2010
In my production -- we have 3 nodes Primary RAC with 2 Nodes Physical secondary Standby RAC. Due to some reason we will have to failover means 3 nodes Primary Standby RAC to 2 Nodes secondary physical Standby RAC. share Steps for Failover ( not switchover) from 3 Nodes Primary RAC to 2 Nodes Physical Standby RAC. I know this is generic and can be find from google but issue is how can failover from 3 nodes primary standby rac to 2 nodes secondary physical standby rac.
View 3 Replies
View Related
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
Feb 7, 2011
Query :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 Replies
View Related
Apr 20, 2011
I have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.
View 1 Replies
View Related
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
Nov 24, 2011
I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.
View 2 Replies
View Related
Dec 25, 2011
when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.
View 8 Replies
View Related