Re: Stored proc and forms4.5

From: George Xu <George_Xu_at_nt.com>
Date: 1997/06/12
Message-ID: <33A0BA5A.432E_at_nt.com>#1/1


Mark Aurit wrote:
>
> We call a stored procedure from a forms application
> using the stored procedure name, and the app compiles
> fine.
> However, when we refer to the stored procedure
> by a public synonym we create for it, we get a:
> Error 313 at line 21, column 11
> 'S_ROLLBACK_TRANSMIT' not declared in this scope
>
> Can anyone help? Ive done all I can think of.
> Thanks, Mark
> ***********************************
> Procedure/synonym SQL:
> create procedure rollback_transmit ( act_date date )
> as begin
> update s_tc_hdr_tot
> set ht_status_in = ht_p_stat_in
> where trunc(det_active_da) = trunc(act_date);
> commit;
> end;
> /
> show errors;
> grant execute on rollback_transmit to public;
> create public synonym s_rollback_transmit
> for rollback_transmit;
>
> Forms 4.5 trigger:
> s_rollback_transmit(:rollback.emp_detail_da);

Try change your stored procedure name. Good luck. George_Xu Received on Thu Jun 12 1997 - 00:00:00 CEST

Original text of this message