How can i use this below example in forms builder 10gr2
var oput_cur refcursor
var tabname varchar2(30)
exec :tab_name := 'dual';
begin
open :oput_cur for 'select * from ' || :tabname;
end;
/
print oput_cur
how can i get the values from oput_cur into forms grids(containing text items).
I have got two tables emp_dtl and iou_tab. i have already made entries i.e booking no, emp_cd, emp_name etc in emp_dtl snc its my master table. I want to retrieve the booking nos through lov in iou_tab which are generated in emp_dtl and corresponding info of emp_cd and emp_name should come in the respected fields in iou_tab.
View 1 Replies View RelatedI am working on Oracle forms 10g (Windows 7 OS).I have got one requirement to show one LOV for COLOR table. Say i have three colors BLACK, RED, BLUE in color table. Suppose in a multi record block if a user selects BLACK from a lov for one record then for the next record lov it should show only RED and BLUE. How to filter the COLOR from a LOV record group query which are already selected?
View 1 Replies View RelatedThe goal is to create a stored procedure that will retrieve multiple values from a table.
GUI is in Java and they will trigger our procedure to show list of all employees and their roles , doj etc.
So I wrote the following procedure.
---------------------------------
create or replace
PROCEDURE emp_test(
c_cursor OUT SYS_REFCURSOR)
AS
BEGIN
OPEN c_cursor
FOR
SELECT emp_name, emp_doj, emp_role FROM emp_table ;
END;
---------------------------------
I'm using sql developer, stored procedure is compiled and I can manually run it by right clicking on the procedure and click 'Run'.
When I intend to run it by executing the script "Execute Procedure name ", I get errors.
In SQL Developer, I open new SQL file and key in
EXECUTE emp_test;
Highlight it and run the script, here is the list of errors that I get.
-------------------------------------------
Error starting at line 18 in command:
execute frm_lst
Error report:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'emp_test'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:
%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
--------------------------------------------
Issue 2:
Instead of using cursor, is there a way to use multiple parameters and insert the data retrieved from select column_name from table into these parameters and build it in a stored procedure. I tried something like below which did not work.
____________________________________________________
CREATE OR REPLACE PROCEDURE emp_test1
(e_name OUT emp_name%TYPE,
e_dob OUT Edob%TYPE)
IS
BEGIN
SELECT emp_nam, Edob
INTO e_name, e_dob
FROM emp_table
END emp_test1;
End;
______________________________________________________
Just so you know, there is no input parameter or input feed, when called the procedure should return all the values.
i want to use Graphic builder for make a chart in report builder. how can i use them for create a chart report? i need to see some samples for create my project. put a sample of .OGD and .rdf
View 6 Replies View Relatedi have created two data blocks
First data data block contains a list item and a text item based on the selection of the list item and the value in the text item i need to retrieve more than one row in another data block whose NUMBER OF RECORDS DISPLAYED property are set to 10.
I have a Button in the first data block. So in the WHEN BUTTON PRESSED trigger i wrote SELECT INTO clause which is raising "exact fetch returns more than requested number of rows".Then i used a cursor in the WHEN-BUTTON-PRESSED trigger in the first block to fetch row by row and assign it to the items in second block. But i am able to retrieve only one record in the second block.
I have two blocks on which I am having relation based on booking number and employee code. As I am doing a query, booking number is getting fetched in employee code's field and employee code is getting fetched in booking number's feild. Because of this, I am not able to update the form. It is giving me error unable to update record unique contraint voilated for primary key which is quite obivious. But why the data could get shuffled in each others field though during inserting its going properly.
View 7 Replies View RelatedI have two string one is comma separated values as a column name and another string which is having the comma separated value corresponding to the column name.
Example:
string1:='col1,col2,col3'
string2:='1,aaple,'2-jul-75'
now i have to create and run a query which will be like that
select * from emp where col1=1 and col2='apple' and col3='2-jul-75'
I want if the user write for example in text box 'AM TK' the query display the resualt which has am alone tk alone, and that has both. I know that i should use the Like with % but i do not know how to write it in the set property. I have wrote
set_block_property('Employee_Other',default_where,'Upper(name) like '''||UPPER(:key_search.person_name)||'''') ;
This will bring the resualt just if the user write am tk. How i can modify it to return value as i explained above.
I am trying to retrieve images from the file system, but the open dialog box is not popping up for me to choose which file i want. It does nothing gives no error. Just says record 1/1 on the message bar at runtime.
I have two blocks on the module. One is the lobs_table block and the other is the control block. On the control block i have a when-button-pressed trigger on an item. And here is the code below.
Declare
jpg_image_dir VARCHAR2(100) := 'C:UsersajayiaDesktopMe_pics';
photo_filename VARCHAR2(100);
BEGIN
:System.Message_Level := '25';
[code]......
I don't know the code to use to get forms to bring up the open dialog box.
I have a requirement to execute the query only once for all the columns mapped to a particular table. Lets take an example..
table t1 has the following columns mapping.
col1 col2 col3 col4
variable 1 table abc col1_abc ----
variable 2 table abc col2_abc ----
variable 3 table xyz col1_xyz ----
variable 4 table xyz col2_xyz ----
variable 5 table xyz col3_xyz ----
variable 6 table xyz col4_xyz ----
In col4 , we have to update the values of col3 (column) ... it is very easy to update the values by executing the query for each column but my requirement is ... I want to execute the query once for a table ( example select col1_abc,col2_abc from table_abc ... this will return always a single value after adding other conditions in where clause) and why I want to do this? .. because there can be multiple (might be 30 variables values)
from a single table.
I have converted the columns into rows by using listagg function now I have lets a dynamic query ( for the above example).
for i in 1.2
loop
l_query := ' select col1_abc, col2_abc from table_abc';
open c1 for l_query;
end loop;
my problem is : how to hold these values and update the above table?
how to assign the values by taking the values on LEFT HAND SIDE DYNAMICALLY.
Say if I have a,b,c,d in an array then I need to take variables from the array and assign some values to it. Like a=1;b=2;c=3;d=4;
We are planning to migrate the forms application from windows to linux.
View 1 Replies View Relatedhow can i insert a image by selecting an image from any drives of my system to oracle database and retriving that image for displaying purpose after inserting that image. if possible give me a sample form. like vb 6.0 or vb.net in textbox's change trigger fires instantly when we start typeing in the text boxes.
View 6 Replies View RelatedI am creating a record with the items - S_No, Product_Name, Selling_Qty, Price.
Checking the total qty (Tot_Qty) from the purchase stock - table1 and already sold out qty (Sold_Qty) of the product from table2.
Consider the following values: Tot_Qty = 200; Sold_Qty = 50;
Now i create a first record of the form as follows: here on selecting the Product_name from LOV, will display the Selling_Qty item - which can be edited (Selling_Qty = Tot_Qty - Sold_Qty) and its price.
S_No Product_Name Selling_Qty Price
1. KeyBoard 50(150) 200
2. KeyBoard 30(150) 200
3. KeyBoard 50(150) 200
Note:
[value given within () are displayed automatically after selecting the prod]
My prob is, when i am entering next record, it displays the same 150 as qty, which have to be 100. After selecting the product from LOV, it should calculate & validate as shown below: which means, previous record value of Selling_Qty also have to be subtracted and displayed.
S_No Product_Name Selling_Qty Price
1. KeyBoard 50(150) 200
2. KeyBoard 30(100) 200
3. KeyBoard 50(70) 200
Is there any built-in functions to retrieve previous record value?
if i can run an exe application ('Hello World!')from forms builder,is there a specific command?
View 1 Replies View RelatedThe Link for free download of Oracle Form builder 10g software ?
View 7 Replies View RelatedI am using Oracle Form Builder and Graphics Builder 6i. In Graphics Builder I create a graph from this query view but in result my result is reverse which i want..
==============================================================
Create or Replace View V_Mnth_Attn as
select
emp_id, max(nm) name, max(cid) cmp_id, max(dpt) dpt_id,
min(case when to_char(dt_attend,'dd') = '01' then abrr end) "D_1",
min(case when to_char(dt_attend,'dd') = '02' then abrr end) "D_2",
min(case when to_char(dt_attend,'dd') = '03' then abrr end) "D-3",
min(case when to_char(dt_attend,'dd') = '04' then abrr end) "D-4",
[code].....)
because i want values in graph of all columns but i got only employee id on values and on get all values on x axis .
Trying to translate FMB (Base Language-English Translation language-French) . Have followed all the steps as given in a metalink Note:70117.1
Create a project and module and add a version and add a translation and then export the strings to same fmb
As per the note I should see the french labels etc when I set the NLS_LANG as FRENCH_FRANCE.WE8ISO8859P1 and run the form But I still see the English labels.
What am I missing ,
-- The note points out to install French Fonts but I don't know which fonts to install and how to install them from ?
-- Also Do I need to select a french font and script using Edit > Change Translation Font in the Translation Editor before exporting the strings ?
I notified some strange behaviour of my forms debugger. When I insert debug.attach piece of code into ma form and fired them on Windows machine after inserting into Oracle forms builder debugger dialog box server name (usualy ip) and given port from oracle forms window then everything works fine, breakpoint is catched. But when I changed my OS to RedHat then I am not able to come into all kind of trigger form code. Only program units could be debugged.
View 7 Replies View Related1.steps to create master-detail form using form builder 6i ,db oracle 9i.
2.Using dept and emp(database table)
3.one more thing difference between cascading/isolated while creating relation b/w dept and emp using join method
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 RelatedI installed forms builder 6i as I am making a change to a custom form which was created in 6i. When I attempt to use the layout editor, it crashes immediately. The dll module that it seems to get stuck on is uiw60.dll. I have this file on my machine. I added the directory location to the FORMS60_PATH in the registry as it was missing but I am still crashing. The version of 6i I have is 6.0.8.11.3.
View 1 Replies View RelatedI am using forms 10.1.2.0.
I am try to open one .fmb file but file is not open in form builder.Its shows message "cannot open file".
I am going to help button its told that fmb in not create in that form builder. but that fmb is made in 10g but now is not open.
i have problem when use trunc function in form builder i have two cloumn first column inserted data is 15.55 and i want the secound cloumn the will be too 15.55
i used this code but nothing happened
select sum(trunc(item_name,2)
into column2
from table_name
always the result be 16 i want it 15.55 without any round to this value
I used Report Builder 9.0.4.0.33, and i want to call 1 report name is "DOCK_RECEIPT.rdf" from Form when click into button name is "Print". I write code in When-button-press follow: This is code call report from Form.
Declare
pl_id paramlist;
Begin
pl_id := get_parameter_list('tmpdata');
[code]....
On report "DOCK_RECEIPT" has parameter same parameter on Form. But when i click button "Print" then can't call report,while form and report that together folder.Now, i want to question, how must configure report builder for call report from form that? example: about directories,path, etc
I am using Oracle Forms Builder 6i. When you open it, in the navigator tree:
- Forms - MODULE - Reports
I want to know what is the purpose of REPORT section in the Forms Builder.
I am using Oracle forms builder 10g version. Since last week, I can't open layout editor of any of the forms using my builder tool. I tried rebooting, restoring, creating new form etc. Some times it works, but after a couple of hours the issue returns.
View 13 Replies View Relatedi want to create a form like a console with form builder 6i for databases monitoring. I have to connect to more than 10 databases and monitoring them at same time.
My question is, how can i create connection string for each one in form builder? after connect to per database i want to select some quires, for example
:
"select STATUS from v$instance;"
Attention: i don't want use db-link
i'm facing a problem when i run form om forms 11g
that error appears :
frm-10142 HTTP listener not running on weblogic on port 80
and when i ran it on weblogic server after compiling it on internet explorer a blank window appear and written DONE