Assalamu 3licom
Many thanx for all help given by this forums
my problem is simply defined as follows
I created a procedure with variables in a form and i want to call it in the same form using a button
i wrote in that trigger "proceduure_name;" do it returns this error
" Error 306
wrong number or types of arguments in call to 'procedure name'

please advise and feed back me ASAP
Gazakom allaho 7'yrn
Many thanx in advance
or u can contact me on this e-mail
[email protected]

Dear

When you call a procedure with parameter you must pass the same number of parameter to the procedure
as the followng example

CREATE OR REPLACE PROCEDURE query_emp
(p_id IN employees.employee_id%TYPE,
 p_name OUT employees.last_name%TYPE,
 p_salary OUT employees.salary%TYPE,
 p_comm OUT employees.commission_pct%TYPE)
IS
BEGIN
SELECT 	last_name, salary, commission_pct
INTO 		p_name, p_salary, p_comm
FROM 		employees
WHERE 	employee_id = p_id;
END query_emp;
/

VARIABLE 	g_name VARCHAR2(25)
VARIABLE	g_sal NUMBER
VARIABLE 	g_comm NUMBER
EXECUTE 	query_emp(103, :g_name, :g_sal, :g_comm)
PRINT 		g_name

you can apply the same concept in the form


Best Regards

Osama Soliman

Many thanx for ur reply
we already solve it
jazakom allaho kyrn