Home » Developer & Programmer » Forms » GET_FORM_PROPERTY
GET_FORM_PROPERTY [message #381137] Thu, 15 January 2009 06:50 Go to next message
mylraj
Messages: 16
Registered: January 2009
Location: Manama
Junior Member
Hi,

can anyone please solve this

i am getting an error

frm 40738 argument 2 builtin get_form_property can not be null


FORM_NAME:=:SYSTEM.CURRENT_FORM;
--MESSAGE(FORM_NAME);
FIRST_BLOCK:=GET_FORM_PROPERTY(FORM_NAME,FIRST_BLOCK);
LAST_BLOCK:=GET_FORM_PROPERTY(FORM_NAME,LAST_BLOCK);

Regards
Re: GET_FORM_PROPERTY [message #381141 is a reply to message #381137] Thu, 15 January 2009 07:23 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Oracle Forum Says...

Quote:
This usually occurs when an exception occurs in a plsql block in the form, like under when new form instance or when button pressed. The form can still be closed by clicking on the 'x' of the form itself, not the warning window.

Follow the instructions of the headstart manual on how to implement the when-button-pressed code (look at the example). You may want to play with the unhandled_exception line, since in some of my cases this line causes the unwanted behaviour.



http://forums.oracle.com/forums/thread.jspa?messageID=596514

Javed

[Updated on: Thu, 15 January 2009 07:24]

Report message to a moderator

Re: GET_FORM_PROPERTY [message #381142 is a reply to message #381137] Thu, 15 January 2009 07:29 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wouldn't name my variables as you did; why wouldn't you rather do something like
  my_first_block varchar2(30);
begin
  my_first_block := get_form_property(:system.current_form, first_block);
end;

Generally speaking, it is a bad idea naming any of your objects (columns, variables, tables, ...) by using a name of (potentially) Oracle reserved word or keyword. If it smells like it, don't use it; there are many other possibilities (such as MY_, L_ (as "Local_") etc.).
Re: GET_FORM_PROPERTY [message #381559 is a reply to message #381142] Sun, 18 January 2009 05:58 Go to previous message
mylraj
Messages: 16
Registered: January 2009
Location: Manama
Junior Member
Thanks for your reply,it works fine now

Previous Topic: Help ASAP-Can't login as Hrms/hrms@lid as sysdba at forms/Reports developer
Next Topic: determining cd rom's drive letter in forms 6i
Goto Forum:
  


Current Time: Tue Dec 06 14:19:04 CST 2016

Total time taken to generate the page: 0.05846 seconds