OraFAQ Forum: Forms » calling procedure

Home » Developer & Programmer » Forms » calling procedure (Oracle IDS ,10g,Windows Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

calling procedure [message #388997]

Thu, 26 February 2009 22:24

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

I have created procedure in program units.I placed pushbutton in my form.In progrmunits I have written following code

PROCEDURE sample(id number,name varchar2,mar number) IS
v_row stud%rowtype;
BEGIN
	v_row.studid := id;
	v_row.studentname := name;
	v_row.major := mar;
	insert into stud values (v_row);
  
END;

my question if I press the push button above the procedure will be execute i mean record will insert inthe table.

Send Solution

Thanks and Regards

Varosh

Report message to a moderator

Re: calling procedure [message #389013 is a reply to message #388997]

Fri, 27 February 2009 00:15

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is not a question, but a statement.

Quote:

if I press the push button above the procedure will be execute

Yes, if a trigger associated with the push button calls this procedure. If you don't press the button, nothing will happen.

Quote:

i mean record will insert in the table.

Maybe, who knows? It is your procedure, your form, you should test it. Did you test it? What has happened?

Report message to a moderator

Re: calling procedure [message #389115 is a reply to message #389013]

Fri, 27 February 2009 05:47

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

sorry sir

what code i write the pushbutton to call the procedure.

Thanks and regards

varosh

Report message to a moderator

Re: calling procedure [message #389248 is a reply to message #389115]

Fri, 27 February 2009 15:03

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How to call it? By using its name and arguments, such as

sample (:block.id, :block.name, :block.mar);

Report message to a moderator

Previous Topic:	% progress bar
Next Topic:	Master/Detail/Detail block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 24 23:24:57 CDT 2026