Home » Developer & Programmer » Forms » Need your help on ORA-306500
Need your help on ORA-306500 [message #295781] Wed, 23 January 2008 07:27 Go to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hello ,
Thanks a lot for help me to convert forms from 6i to 9i.

Now when i run that form on 9iAS, then at some events it throws some error in backend like

1)WHEN-BUTTON-PRESSED trigger unhandle exception ORA-306500 (this error occur when i click on button)

2)WHEN-MOUSE-DOUBLECLICK trigger unhandle exception ORA-306500
(this error occur when i doubleclick in grid)

What is solution for this, so that it wil work fine ?

Thanks,

Shekhar

[Updated on: Thu, 24 January 2008 08:50] by Moderator

Report message to a moderator

Re: Need your help [message #295905 is a reply to message #295781] Wed, 23 January 2008 21:55 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Anybody pleasr Help me....

Also some forms are not displayed completely because of fixed size in the browser.....?

Thanks
Re: Need your help [message #295915 is a reply to message #295781] Wed, 23 January 2008 22:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post the error message text as well as the error message code.

David
Re: Need your help [message #295916 is a reply to message #295905] Wed, 23 January 2008 22:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at the solution given here http://www.orafaq.com/forum/m/293100/67467/?srch=formsweb.cfg+height#msg_293100

David
Re: Need your help [message #295944 is a reply to message #295916] Thu, 24 January 2008 00:02 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Thank a lot, to have valueable suggestion
Form display is solved...
,but still i have big problem with event's interaction on form component(like button,LOV'S) which not fires on converted forms form 6i to 9i in browser .

What i have to send that you wil realize my errors more conveniently? you said to post code and errors but how could i send it?

Thanks once again.
keep replying... (you help me too much last 4 days)
Re: Need your help [message #295946 is a reply to message #295944] Thu, 24 January 2008 00:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Type the words that appeared on the screen after the error code 'ORA-306500' in your reply.

David
Re: Need your help [message #295963 is a reply to message #295946] Thu, 24 January 2008 00:54 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
When i checked at backend if some events not work then
Following error occur in error_log table when form run:

WHEN-MOUSE-DOUBLECLICK trigger raised unhandled exception ORA-306500

WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-306500


Re: Need your help [message #295971 is a reply to message #295946] Thu, 24 January 2008 01:10 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
In short some trigger is not working..
I think this may be due to form upgrade in 6i to 9i

Sir, please help me.
Re: Need your help [message #296035 is a reply to message #295781] Thu, 24 January 2008 05:04 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Antbody is there?
Please help me..
Re: Need your help [message #296037 is a reply to message #295781] Thu, 24 January 2008 05:33 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Hi,

Without knowing what you are doing in your triggers it's tricky to help.

I did find this posting about the error you are encountering
ORA-306500
which might be helpful.

Re: Need your help [message #296055 is a reply to message #296037] Thu, 24 January 2008 07:05 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
In that application, on Mouse-Doubleclick posting some data to back canvas.
If you realize my problem then plese reply me soon.

Thanks
Re: Need your help [message #296069 is a reply to message #295781] Thu, 24 January 2008 08:17 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
How about this link ora-306500 - they seem to have had the same problem as you?
Re: Need your help [message #296141 is a reply to message #296069] Thu, 24 January 2008 17:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this SITE using the 'Site Search' facility for 'ora-306500' and one of the other links may help you if the one above does not.

David
Re: Need your help [message #296159 is a reply to message #296141] Thu, 24 January 2008 22:10 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hello sir,

Does it because of mine oracle form upgrade in 10g !! doesn't it?
If so then what should I do?
Re: Need your help on ORA-306500 [message #296228 is a reply to message #295781] Fri, 25 January 2008 03:12 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Have you looked at the links I posted?

Are you using EXEC_SQL in your triggers? If you are follow the solutions in the links.

If you aren't then post the code (correctly formatted) that is in your triggers.
Re: Need your help on ORA-306500 [message #296571 is a reply to message #296228] Mon, 28 January 2008 05:22 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hello sir,
Here is the code which is on Mouse-Double-Click:
/////////////////////////////////////////////
DECLARE
VSQLWhere VARCHAR2(32767);
BEGIN
break;
:BLOCK.TXTGMST := GRIDBLOCK.GMST_CODE;
vSQLWhere := fun_Get_Search_Data;
HIDE_VIEW('CANLOC');
HIDE_WINDOW('WINLOC);
SET_VIEW_PROPERTY('SRCHCANVAS',VISIBLE,PROPERTY_OFF);
SET_VIEW_PROPERTY('CANVAS',VISIBLE,PROPERTY_ON);
SET_VIEW_PROPERTY('TABCANVAS',VISIBLE,PROPERTY_ON);
IF(VSQLWhere IS NOT NULL) THEN
:VAR.TXTWHERE := vSQLWhere;
GO_BLOCK('DATABLOCK');
CLEAR_BLOCK(NO_VALIDATE');
SET_BLOCK_PROPERTY('DATABLOCK',DEFAULT_WHERE,:VAR.TXTWHERE);
EXECUTE_QUERY(ALL_RECORDS);
proc_Show_Hide_Contact;

End If;
proc_Refresh_Buttons(:VAR.RECENT);
SET_ITEM_PROPERTY('CONREOLBLOCK'.CMDADD,ENABLED,PROPERTY_ON);
GO_ITEM('CONTROLBLOCK'.CMDLOCATE)
End;

////////////////////
Please Help me..
Thanks.
Re: Need your help on ORA-306500 [message #296641 is a reply to message #296228] Mon, 28 January 2008 08:40 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hello ,
I m very glad to saying that the problem is solved, and its now working because of some pll are not attached.
Smile Smile

But few more problem still i m facing.
1)One function is working before removing previous problem now all other problem is solved, but first is not working... Sad

2)Position of Applet is changing when in the application, so if I look that canvas, only part of applet is visible

What should I do?

Thnaks a lot.
Re: Need your help on ORA-306500 [message #296998 is a reply to message #296641] Tue, 29 January 2008 21:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
1) What message is it giving you?

2) Take a screen shot, save it as a JPG, and attach it to your response.

David
Re: Need your help on ORA-306500 [message #297690 is a reply to message #296998] Sat, 02 February 2008 09:22 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hello ,

I am getting following problem at the time of form loading on browser.

FRM-40112: Attmpted go_item to non enabled item CONTROLBLOCK:CMDCANCEL


If I comment all go_item('CONTROLBLOCK.CMDCANCEL'), still its given me error.
And One more interesting thing that, IN the pl-sql there is go_item('CMDCANCEL'), if I comment that line then error does not occur but btncanvas gone to invisble......

I am totally hang-over in this situation.
Please Help me..

Regards
Re: Need your help on ORA-306500 [message #297705 is a reply to message #297690] Sat, 02 February 2008 11:40 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This error says that you are trying to set the focus into an item which is not enabled (i.e. you can't put the cursor and write some text into it). So - GO_ITEM to an enabled item instead (or enable 'cmdcancel').
Re: Need your help on ORA-306500 [message #297821 is a reply to message #297705] Sun, 03 February 2008 22:52 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hello

These problem was in 6i also but at that time they simply ignore that errors.
But now after compile in Form developer 9i it throws such errors(alert) at runtime. And it is not working properly..

Help me, I am very confused.
Does it work properly in 9i as work in 6i?

Regards
Re: Need your help on ORA-306500 [message #297833 is a reply to message #297821] Sun, 03 February 2008 23:07 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Obviously, (9i <> 6i) => fix the error.
Re: Need your help on ORA-306500 [message #297843 is a reply to message #297821] Sun, 03 February 2008 23:25 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Oracle Forms 9i is MUCH tighter than Forms 6i. You will also have to make sure that receiving fields of an LOV are big enough or that the displayed field is shortened to fit into the receiving field. You will also have to remove cyclic calls between PLL files.

David
Re: Need your help on ORA-306500 [message #297844 is a reply to message #297833] Sun, 03 February 2008 23:26 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hello

Should I set the property console window=null & comment on go_item() line?
Re: Need your help on ORA-306500 [message #297846 is a reply to message #297844] Sun, 03 February 2008 23:28 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
No, just change the code so that you go to a field that is enabled.

David
Re: Need your help on ORA-306500 [message #297916 is a reply to message #297846] Mon, 04 February 2008 04:07 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Sad
But If I change
go_item('CONTROLBLOCK.CMADD');
intead of
go_item('CONTROLBLOCK.CMDCANCEL');
then btncanvas is not visble.


Regards,
Re: Need your help on ORA-306500 [message #297920 is a reply to message #295781] Mon, 04 February 2008 04:13 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
FRM-40112: Attmpted go_item to non enabled item CONTROLBLOCK:CMDCANCEL

the text item cmdcancel is not enabled.Go to its property and enable it.
Previous Topic: how to set iconic path in the variable UI60_ICON through registry?
Next Topic: Export query to excel
Goto Forum:
  


Current Time: Sat Dec 10 08:45:55 CST 2016

Total time taken to generate the page: 0.08288 seconds