Hi Guys,
managed to get it sorted. The problem was when I was recalling the
procedure, I was passing in one parameter incorrectly which resulted
in the cursor never ending and killing the procedure.
LINES:
get_end_assy
(p_org_id,p_alt_id,p_current,ass_rec.parent_item,x_indent,p_insert);
should have read
get_end_assy(p_org_id =>p_org_id
,p_alt_id =>p_alt_id
,p_current =>ass_rec.parent_item
,p_parent =>null--ass_rec.parent_item
,p_indent =>x_indent
,p_impl_seq_no =>p_impl_seq_no
,p_insert =>p_insert);
Thanks for all your help.
Chris
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
