Forms :: Form Closes While Compiling
Jul 20, 2010
I have a form, using views which has tables from other databases.
e.g. :my database name is G1 here i have a view
MR_HEAD
CREATE OR REPLACE VIEW MR_HEAD AS
SELECT "MR_HEAD_KEY","MR_TRAN_TYPE","MR_NO","MR_DATE","PO_TYPE","PO_NO","VENDOR_CODE",
"MODIFY_FLAG","SUPERSEDE_FLAG","REF_MR_HEAD_KEY","PO_KEY","PO_DATE","REJECTION_NO",
"USER_ID","LAST_UPD_DATE"
FROM INMATMAS.MR_HEAD@SPICFIN
i am linking my database G1 with Above Database. so after using this in my form as
'INMATMAS.mr_head@DB_OPTIMAT'[/email]
for insert/select. i cant able to compile it. form closes immediately when i compile this.
what must be the reason,
View 15 Replies
ADVERTISEMENT
Dec 6, 2010
i have create database link with msaccess2000 its working fine in forms 6i i am trying to upload data by using forms 6i while compiling form is automatically closed my code is this
begin
insert into baba1
(select *
from baba1@access_db
where dte between to_date(:block3.fdate,'dd-mon-yyyy')
and to_date(:block3.ldate,'dd-mon-yyyy')
[code]....
View 8 Replies
View Related
Oct 22, 2011
I am getting this err ora-31640 while compling a menu in forms6i and when i have searched in oracle it is giving in forms 6i shared submenu's are not supported.
View 1 Replies
View Related
Sep 3, 2010
while compiling this package body, i get error
error 102 at line 21 column 11
encounterd symbol "Group" when expecting one of following
begin function package pragma procedure subtype type use form cursor
View 5 Replies
View Related
Mar 15, 2010
i am getting compiling error when using bulk collect in oracle form 10g
Quote:this feture is not supported on client-side programs
View 3 Replies
View Related
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
Apr 16, 2013
Having trouble installing Oracle 11g. After I select system class, the installer just closes out. I have re-download the software from the Oracle and made sure both files were unzipped into the same folder correctly. Searching around this forum found same problems, none of the solutions have worked so far. Tried setup -jreLoc (Location of Java), tried using it with different versions of java. If it tries to start the installer it gives an error about not being able to locate java runtime.
Specs: Windows 7 Ultimate x64
8GB Memory
930GB Free (on drive i want to install oracle on)
Files Download:
win64_11gR2_database_1of2.zip
win64_11gR2_database_2of2.zip
View 11 Replies
View Related
Jul 19, 2010
If I open a form has attached libraries in form builder on windows7 it closed and give this message :
Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll
[code]......
View 14 Replies
View Related
Apr 16, 2013
I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.
View 1 Replies
View Related
Jul 15, 2007
I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.
How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?
View 13 Replies
View Related
Nov 13, 2012
i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
View 3 Replies
View Related
Mar 11, 2010
is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.
View 1 Replies
View Related
May 21, 2010
I have a requirement, is there any way i can achieve the following User Interface using oracle forms
Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.
The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.
View 2 Replies
View Related
Dec 20, 2012
I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.
In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.
This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.
View 2 Replies
View Related
Mar 1, 2010
What is the difference and significance of
1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?
View 5 Replies
View Related
Jun 11, 2012
How to see the error Oracle is returning?
SQL> select owner, object_name, object_type from sys.dba_objects
2 where status = 'INVALID' order by owner;
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
CRMAPP
CRM
PACKAGE BODY
SQL> alter package CRMAPP.CRM compile;
Warning: Package altered with compilation errors.
SQL> show errors;
No errors.
SQL> select owner, object_name, object_type from sys.dba_objects
2 where status = 'INVALID' order by owner;
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
CRMAPP
CRM
PACKAGE BODY
View 2 Replies
View Related
Jan 3, 2012
i am new to oracle,when i am compiling below procedure,
create or replace procedure GetTempPolicyDetails2(i_officeid in number,pr_cursor out SYS_REFCURSOR) as
L_QUEY VARCHAR2(4000):= 'select POLTMP.POLICY_ID,POLTMP.CORPORATE_NAME,POLTMP.POLICY_FROM_DATE,POLTMP.POLICY_TO_DATE,
POLTMP.NETPREMIUM_WITH_SERVICE_TAX,
IOF.OFFICENAME,UW.NAME,REG.REGNAME,brmstr.brokername,created_on
from policies_temp POLTMP
INNER JOIN ISSUINGOFFICE IOF ON IOF.ID=POLTMP.Divisionid
INNER JOIN REGION REG ON REG.ID=IOF.RID
INNER JOIN underwriters UW ON UW.ID=REG.UWID
LEFT OUTER JOIN broker_master BRMSTR ON BRMSTR.ID=POLTMP.Broker_Name
where POLTMP.Policy_Status=1 where 1=1'
L_WHERE VARCHAR2(4000):='WHERE 1=1';
[code]....
View 5 Replies
View Related
Feb 10, 2012
I have a requirement to reformat some data elements that consist of two numbers separated by a hyphen e.g. 123-456. I have written a function to get the first number but it compiles with a warning.
CREATE OR REPLACE FUNCTION get_lowernumber
(housenumber varchar2)
RETURN varchar2
IS
v_hyphen number;
[code].......
View 8 Replies
View Related
Jul 31, 2012
I'm getting the following error on a procedure that I was able to compile until today after some changes.
ORA-06550: line 354, column 20:
PLS-00103: Encountered the symbol "AND" when expecting one of the following:
. then or
The symbol ". was inserted before "AND" to continue.
View 6 Replies
View Related
Apr 10, 2013
I am trying to resolve by using a cursor C2 inside the already existing cursor C1, i will use a inner loop to get the select statement value to cursor c2 then i will assign the vlaues the variables, then once i read all the values of cursor c2 i will exit inner loop and go to outer loop to read the next value of c1 and then again go to cursor c2 and inner loop.
I have pasted the code below.
Declare
temp1 source.source%type;
temp2 QUOTE_LETTERS_MASTER%rowtype;
Cursor c1 is
Select * from Source;
[code]...
View 5 Replies
View Related
Aug 25, 2010
Up until today we assumed that compiling a package BODY-only would not cause invalidation of other code. However when we compiled the body of the HTP package, the OWA package became invalid and required re-compilation.
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE10.2.0.4.0Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
View 6 Replies
View Related
Jun 28, 2011
When i compile the package body i get errors.
CREATE OR REPLACE PACKAGE BODY CEE_OSPCM_PKG AS
PROCEDURE CEEOT_WORK_TYPE_PRC IS
CURSOR CUR_WORK_TYPE IS
SELECT *
[code]...
View 7 Replies
View Related
Aug 17, 2012
I'm having a problem pr-compiling gtk functions in c files.
View 14 Replies
View Related
Sep 27, 2013
It's been some time since I've written any PL/SQL, I'm getting Found 'CURSOR' Expecting: External Language for line 76 when I try to compile? :
1 create or replace PACKAGE pa_user_maint
2 AS
3
4
5 -- ------------------------------------------------------------------------------------
6 -- Exceptions
7 -- ------------------------------------------------------------------------------------
8
9 -- User Exists
10
11 ex_existingUser exception;
12 PRAGMA EXCEPTION_INIT (ex_existingUser, -01920);
13
[code].......
View 1 Replies
View Related
Dec 18, 2008
We are porting our application from HP-UX to Sun Solaris and as part of that I am trying the compile a Pro*C program in Sun Solaris using SUNWspro C++ compiler. Precompiling is failing with following error.
PRECOMP set: /u01/app/oracle/product/10.2.0/bin/proc dbms=native code=cpp mode=ansi include=/u01/app/oracle/product/10.2.0/precomp
ireclen=255 oreclen=255
define=__sparc define=__SUNPRO_C include=/usr/include include=.
[code]...
System default option values taken from: /u01/app/oracle/product/10.2.0/precomp/admin/pcscfg.cfg
Syntax error at line 44, column 30, file /u01/app/SUNWspro/prod/include/CC/stlport4/algorithm:
Error at line 44, column 30 in file /u01/app/SUNWspro/prod/include/CC/stlport4/a
lgorithm
# include _STLP_NATIVE_HEADER(algorithm)
.............................1
PCC-S-02014, Encountered the symbol "(" when expecting one of the following:
[code]...
Normal C++ files are getting compiled with out eny issues. This particular file is having functions written in C fashion.
View 1 Replies
View Related
Apr 2, 2009
I'm running a query similar to the one that I'm describing below -:
EXEC SQL INSERT INTO TABLE1
( C1
,C2
,C3
,C4 )
[code]....
Above query runs perfectly on SQL prompt.Same query, when being run in a Pro*C program gives compilation error-:
Error at specified line:
,( SELECT D.V3 FROM TABLE2 D WHERE D.V3 = C.V4)
.............................1
PCC-S-02201, Encountered the symbol "D" when expecting one of the following:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
What are the possbile causes of error. I am using Oracle 10g on Unix.
View 1 Replies
View Related
Jan 22, 2013
how to grant compile access for stored procedures..? I got execute access so that i can execute procedure from another user but not able to save/modify once i edited.
i am trying to compile using SQL developer. Error Message :Error: ORA-01031: insufficient privileges
View 5 Replies
View Related
Mar 19, 2011
I am getting the following error while compiling the invalid objects.
ERROR at line 2: ORA-03113: end-of-file on communication channel
I am trying to compile the invalid objects after importing the dump file.
View 1 Replies
View Related
Apr 26, 2011
I have a main form of "sales contract". I want to add sub form to take input for commission & shipment details in separate sub forms.
When I click a button on main form, system should open sub form, in which I enter the detail.
View 4 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