Home » Developer & Programmer » Forms » calling procedure (Oracle IDS ,10g,Windows Xp)
calling procedure [message #388997] Thu, 26 February 2009 22:24 Go to next message
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
Re: calling procedure [message #389013 is a reply to message #388997] Fri, 27 February 2009 00:15 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
./fa/1600/0/

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?
Re: calling procedure [message #389115 is a reply to message #389013] Fri, 27 February 2009 05:47 Go to previous messageGo to next message
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
Re: calling procedure [message #389248 is a reply to message #389115] Fri, 27 February 2009 15:03 Go to previous message
Littlefoot
Messages: 20897
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);
Previous Topic: % progress bar
Next Topic: Master/Detail/Detail block
Goto Forum:
  


Current Time: Wed Dec 07 08:51:37 CST 2016

Total time taken to generate the page: 0.08792 seconds