get this error when a block query is executed after a value has been selected from a LOV. i checked and it gives the ORA-00000 ???non error??? i copied the so called problem query and it executes perfectly in sqldeveloper.
View 6 RepliesI am getting the same error on a form I am setting up under version 10.1.2 Form Builder. But when I press Shift-F1 I get a Getting Started with Internet Explorer popup. I am running the form under OAS. I have a parent/child relationship between 2 tables that I query on the form.
A copy of the fmb file is attached to access it.
ora-00000 normal successful completion error while populating data from Master block to Detail block in Oracle Forms 11g.
View 6 Replies View RelatedI have several forms developed in Oracle forms builder 10g version 9.0.4.0.19. It contains Hierarchical Tree items. when i run this form on this version of oracle, it's running properly. but when i compile and run it on oracle forms 10 version 10.1.2.0.2, it shows an error message stating Assertion Failed!, if I click on the Tree item. I cant find out what and where the problem is. If I build a new form with tree item, it is working properly.
View 1 Replies View RelatedI have a form with master detail blocks and the block properties are set to no inserts, no updates, and no deletes. When I am at the last record and whenever I navigates to the next record, the system gives a message �FRM-41051: You cannot create records here�. Then the system is not allowing me to go back to anywhere and it insists me with a message �FRM-40202: Field must be entered�. The if I try to exit the form it says �Do you want to call the new form?� How to get rid of this?
View 2 Replies View Relatedi use weblogic and forms11g on windows xp
when i run my from in ie8 or google chorom this error apeared:
Quote:
Error 404--not found
from RFC 2068 Hypertext transfer protocol -- HTTP/1.1 :
10.4.5 404 not found
The server has not found anything matching the rewuest-IRI . no indication is given of whether the condition is temporary or permanent.
So I have an extremely weird error that I just found after several month of being upgraded to 10g from 6i. Right now I have several data blocks where users input data. The field that they input into is fairly long, so we give them the option to double-click which opens up the editor.
Now, if they do this when entering the field for the first time, everything works great. However, if they save, then decide to go back into the data block and edit the field, they can edit it in the text just fine. However, if they double-click and bring up the text editor, after they click ok (or cancel) it jumps back to the first data block.
What is more weird is I can't get it to happen on my own machine, only when it is running on the unix server. On top of that, I was able to avoid the issue by simply showing a message saying "field is about to be edited" and making them click ok. Of course, it's a work-around
I have the form with LOV values. Here i am inserting the values trew scripts in database and get the values from froms. here i am facing the problem like if i tried to select some values in LOV it is saying the error FRM-40200.
View 4 Replies View RelatedWe are migrating our application to 11.1.2 and we encountered a problem with the Win_Api function.
For example if we run Win_Api_File.File_Size on Oracle server 11g 32bit it works but on the 64bit version when it loads the d2kwut60.dll through ORA_FFI.Load_Library raise the ora-304500 NON Oracle exception.
We tried all possible solution and look all over the web with different searching key, but nothing founds. There is a d2kwut60.dll or ffisamp.dll specific for 64bit? There is a workaround?
forms version 10.1.2.0.2
When i make signature for jabor.jar and frmwebutil.jarBy sign_webutil.bat c:DevSuiteHome_1formsjavafrmwebutil.jar sign_webutil.bat sign_webutil.bat c:OraHome_2formsjavajacob.jar
I am receiving these error mentioned in bmp file attach with this topic.
i am getting ora-12713 error in oracle forms output whle displaying text in textbox.
ORA-12713:character data loss in NCHAR/CHAR conversion
ORA-01403 : no datafound.
these two erros are cuming together in oracle 11g and some data is lossing. other its displaying.
I'm trying to install forms 10g on my windows 2000 professional os which is having oracle 9i client. but while installing 10g i'm geting oracle universal installer error. error in writing to directory c:...
My D drive is having 10GB free space and C drive is having 800MB free space (both drive have normal attribute i.e it's not read only ) and oracle have already copied some temp files in C drive (size 13.6 MB) .
I am importing excel data to oracle table by column mapping using forms 6i. I am using ole2 package and i also created one package.which is given below. My code gets compiled, I am unable to insert record to the table.Values are passed to the procedure, i am able to see the values while debugging, but all values are seen in record 1 (as looping is there) all other remaining records are empty.i.e records are changing but seen only in record 1 and all other records are empty.I also get message 'DATA INSERTED INTO THE TABLE' but when i check it with sql, the table is empty.
PROCEDURE get_excel IS
APPLICATION OLE2.OBJ_TYPE;
WORKBOOKS OLE2.OBJ_TYPE;
WORKBOOK OLE2.OBJ_TYPE;
WORKSHEETS OLE2.OBJ_TYPE;
[code]...
I am using oracle forms 11g
when i am running a forms the web page is giving error 404-not found.
I am having a problem in the process of run the Form on web browser.We learned builder Use the Oracle 10g and Oracle Developer Suite 10g
View 6 Replies View Relatedi tried to run the report via oracle froms 10g in BUTTON CLICK. But i got the error like "FRM-41219 : CANNONT FIND REPORT:INVALID ID". I did the Following code.
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
BEGIN
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
[code]....
Problem is one form that i have to migrate from version 6 throu 6i I got very difficult (for me) error FRM-40734. Happens In WHEN-NEW-FORM-INSTANCE trigger when i try do go_block('NAVI');NAVI block is NOT database block (property set NO)
Database Oracle Database 10g Release 10.2.0.4.0
Forms 11.1.2.0.0,
Below i post some code
When-New-Form-Instance trigger
....some other code
navi_pck.link_activated();
... some other code
navi_pck.Init();
... some other code
Navi_pck is a package added to program modules
PACKAGE BODY navi_pck IS
type t_navi_data is record
( name varchar2(64),
primary_item varchar2(64),
[code]...
When When-New-Instance-Form fires on line navi_pck.link_activated(); we go to init(); in navi_pck packageeverything is ok - that mean it is executed without any errorthen when we hit navi_pck.Init();we got error at Bold line => go_block(g_block); that is error not exception (because adding begin... exception when others ... end; does not catch it)
Of course its needed to be done -> mean that go_block, because after it we clear block and work on it.I got 5 triggers on that block NAVE - but tried already to NULL theirs code but didnt solve the problem (didnt try to remove them...)
i m using Oracle 10g release 10.2 database and connecting Oracle Devsuite 10.2 but first time it gives the error of oraut.dll not found. Then this error resolved .
Now when i connecting Oracle devsuite 10.2 's sqlplus with Oracle database then it giving the error of
12560 TNS protocol Adapter error
While i have configured the listener.ora of Oracle 10g database and database is fucting well. but while connecting this to Oracle 10 Devsuite then it gives the error.
i have some form and reports, whenever i call report from forms i got rep-300 OCI invalid_handle_error.
View 8 Replies View RelatedI am using forms 6i. In my program..i am using win_api_dialog.select_printer.I am getting this error frm-40734.
View 5 Replies View RelatedIm generating a csv file using TEXT_IO Utility.The file generated contains one blank line at the last record.Say there is 10 records. Open the generated csv file in notepad and move the cursor down. After 10 records, the cursor will move down one more time.
How to avoid that blank line as im using cursor in my script. The script is attached below.
Version:
Oracle 9i Database
Oracle Forms 6i
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]...
I'm getting this error in my form....
FRM-40735: Formula-CALCULATION trigger raised unhandled exception
How can I find where the issue is?
i have this query :
select barcod
from product
where to_number(to_char(dateexpr,'YY'))=to_number(to_char(SYSDATE,'YY'))
AND to_number(to_char(dateexpr,'MM'))=to_number(to_char(SYSDATE,'MM')+2);
i'm sure the query is correct but how can i fix this error that i'm getting on the form:
error 307: too many declarations of "to_char" match this call
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
I am using windows Xp environment. Downloaded the software from Oracle website. Database is Oracle Express on windows. Have installed Oracle Forms 10.1.2.0.2 and OC4J also on windows xp Installation is fine and i am able to run forms same day. THe next day i am not able to run Oracle forms, i get error frm-92101 error.
I have tried posting this in various oracle forums and have not got a solution yet. I tried reinstalling. Every time i reinstall, it works for a day (the day i install, i have been able to create forms, compile and run them) but it does not work the next day. THis has happened thrice (reinstalled thrice).
Oracle JInitiator: Version 1.3.1.22
Using JRE version 1.3.1.22-internal Java HotSpot(TM) Client VM
User home directory = C:Documents and SettingsuserProxy Configuration: no proxyJAR cache enabled
Location: C:Documents and SettingsuserOracle Jar Cache
Maximum size: 50 MB
[code]...
This error keeps on comming in my welogic forms server window many often....can any one tell me why it is so ?
<Error> <oracle.forms.servlet> <FRM-91230> <fatal
error in runtime process: timeout on connection to Java client>
I am getting following error when we submit request through button in forms.but backend it is created.
ORACLE error 6550 in FDPSTP
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXPL_PO_REQ_INTER_MAIN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
I have data block, after inserting records, in post insert i am using 'GO_ITEM' built_in as i have to move cursor to particular item in another block.
It's giving 'Illegal Restricted procedure' error. How to move cursor to particular item of another block after inserting record?
I'm getting below error. how can we avoid this error?
ERROR: frm-40102 record must be entered or deleted first