Home » Developer & Programmer » Forms » Calling Store Procedures from form 6i
Calling Store Procedures from form 6i [message #84488] Mon, 22 March 2004 10:53 Go to next message
nigist
Messages: 5
Registered: January 2002
Junior Member
 

Hello all,

I am trying to call a store procedure with one parm from form 6i. and on push button when_button_pressed triger i have the following code

begin

P_test(:test.run_dt);

RAISE FORM_TRIGGER_FAILURE;

end;

but it just keep running . what am i doing wrong if this is the correct way to call store procedures. If not how should I call it.

Thanks a lot!
Re: Calling Store Procedures from form 6i [message #84490 is a reply to message #84488] Tue, 23 March 2004 01:03 Go to previous messageGo to next message
simi
Messages: 23
Registered: August 2002
Junior Member
Do you really need a Raise form_Trigger_Failure after you call the procedure. I see no problem in your code calling the procedure, i suppose your procedure is executed but Raise form_trigger_failure is putting a break on......

Still if you face the problem please give some more details about p_test procedure
Re: Calling Store Procedures from form 6i [message #84512 is a reply to message #84488] Thu, 25 March 2004 04:58 Go to previous message
gnanu
Messages: 1
Registered: March 2004
Junior Member
Check u'r p_test code
Previous Topic: Stoping users from altering procedures
Next Topic: Oracle Certified course
Goto Forum:
  


Current Time: Tue Apr 23 14:18:58 CDT 2024