François Degrelle wrote:Hi, Francois
:result is the variable that should store the function return value. What did you expect ?!
Declare v number; Begin v := package.function(...); End;
hope this helps
977083 wrote:Your code can work after check box checked, no need to wait for button press if you use u'r code at
Thanks a lot..
User may select 20-30 check boxes for respective name & id...then at the end , user will hit OK...from here when-button-click will call a procedure....that will update/insert/delete a table data.
Other way if you want in your way,that you mention with the button and your code you can put your code in the button directly. you need to little adjust in your code, something like
And finally, in your scenario you need to pass value in to procedure and make change to make it workable.
go_block('block_name'); first_record; <.......put your code.........>
Should I write anything to commit the data in the table?Yes. you need to write
I am very new to oracle forms...First go through with some basic over net or book and try to implement it.
977083 wrote:let us know the exact error message no a chunk
Thanks a lot to all....Now I am able to insert/update/delete data into/from the table as
I am getting an error like frm-41076 ... no column name or table name or record group is mismatching...
what could be root cause for this error?....please suggest..
hope this helps
select abc.column1,abc.column2,ddd.column1..... from abc,ddd where abc.column1=ddd.column1 ..........
a small fix is needed...for some values in text filed the next block is getting populated...but for some values the next block should not be populated rather should give an error defined by me like "1438:id is not there in the profile selected" ...You can write sql and count the exist record like bellow example
Hope this helps
select count(any_column_name) into a_variable from table where.......; if a_variable =0 then message ('your message'); message ('your message'); raise form_trigger_failure; else your code.... end if;