| QUERY_PROCEDURE tirgger [message #518139] |
Mon, 01 August 2011 10:22  |
 |
msdtjw
Messages: 25
Registered: March 2011
|
Junior Member |
|
|
Hi new problem with this procedure based block. I apparently have the procedure working correctly. but when the QUERY-PROCEDURE trigger was created, it did not have the correct amount of arguments.
My Question is where do I define the 2 input parameters (run_term, run_dept) in the trigger. I don't want to mess this part up.
I think it would need to look like this:
majadv_data.majadv_query(bk_data, '',run_term,run_dept);
But i'm not sure.
My procedure is :
PROCEDURE majadv_query(p_majadv_qry IN OUT majadv_table,
run_term IN varchar2,
run_dept IN varchar2)
Here is the trigger:
DECLARE
bk_data majadv_data.majadv_table;
BEGIN
majadv_data.majadv_query(bk_data, '');
PLSQL_TABLE.POPULATE_block(bk_data, 'MAJADV');
END;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
