Forms :: Error 40505 With ORA-00000?

Feb 4, 2011

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 Replies


ADVERTISEMENT

Forms :: FRM-40505 / Unable To Perform Query Error

May 13, 2010

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

View 11 Replies View Related

Forms :: ORA-00000 Normal Successful Completion Error While Populating Data From Master Block To Detail

May 21, 2012

ora-00000 normal successful completion error while populating data from Master block to Detail block in Oracle Forms 11g.

View 6 Replies View Related

Forms :: Assertion Failed Error On Oracle Forms 10g?

May 4, 2011

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

Forms :: How To Get Rid Of FRM-41051 Error

Jun 23, 2003

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

Forms :: Getting Error 404 Not Found

Nov 20, 2012

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

View 2 Replies View Related

Forms :: Error After Upgrading To 10G?

Mar 23, 2011

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

View 5 Replies View Related

Forms :: Getting Frm-40200 Error In LOV?

Oct 15, 2010

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 Related

Forms :: Getting Error While Using ORA_FFI - 11g 64 Bit

Dec 28, 2010

We 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?

View 6 Replies View Related

Forms :: Getting Error In Signature?

Dec 30, 2007

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.

View 14 Replies View Related

ORA-12713 Error In Oracle Forms?

Oct 11, 2012

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.

View 3 Replies View Related

Forms :: 10g Error In Writing To Directory

Apr 12, 2006

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

View 7 Replies View Related

Forms :: Error 201 Identifier Must Be Declared?

May 15, 2013

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

View 29 Replies View Related

Forms :: Error 404 On Webpage When Running In 11g

Oct 27, 2011

I am using oracle forms 11g

when i am running a forms the web page is giving error 404-not found.

View 2 Replies View Related

Forms :: Plugin Is Not Supported Error

Jul 14, 2013

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 Related

Forms :: Run The Report In Oracle 10g Error

Jul 7, 2010

i 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]....

View 8 Replies View Related

Forms :: FRM-40734 Internal Error?

Dec 13, 2012

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

View 7 Replies View Related

Forms :: TNS Protocol Adapter Error

May 11, 2011

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.

View 2 Replies View Related

Forms :: Rep-300 OCI Invalid Handle Error?

May 8, 2013

i have some form and reports, whenever i call report from forms i got rep-300 OCI invalid_handle_error.

View 8 Replies View Related

Forms :: Frm-40734 Internal PL/SQL Error

Oct 3, 2006

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

Forms :: Error In CSV File Generation?

Apr 12, 2010

Im 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

View 2 Replies View Related

Forms :: Bad Bind Variable Error?

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

Forms :: Getting The Error In Form - FRM 40735

Mar 17, 2011

I'm getting this error in my form....

FRM-40735: Formula-CALCULATION trigger raised unhandled exception

How can I find where the issue is?

View 2 Replies View Related

Forms :: Getting Date - Too Many Declarations Error

Jun 29, 2013

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

View 1 Replies View Related

Forms :: Error 49 Bad Bind Variable?

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

FRM-92101 Error In Oracle Forms

Oct 25, 2008

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

View 1 Replies View Related

Forms :: Java Timeout Connection Error?

Mar 30, 2012

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>

View 2 Replies View Related

Forms :: ORACLE Error 6550 In FDPSTP

Jun 21, 2011

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

View 7 Replies View Related

Forms :: Illegal Restricted Procedure Error

Aug 25, 2011

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?

View 5 Replies View Related

Forms :: ERROR - Record Must Be Entered Or Deleted First

Jul 19, 2011

I'm getting below error. how can we avoid this error?

ERROR: frm-40102 record must be entered or deleted first

View 4 Replies View Related







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