Using :new and :old as parameters to Stored Proc 
Author Message
 Using :new and :old as parameters to Stored Proc
Hi all,

I have a stored procedure on the form
        StoredProc(MyVar IN MyTable%ROWTYPE)
and want to call it from a trigger on the table MyTable using the trigger
variables :new or :old as:

StoredProc(:new);

This seems not to be allowed, however, since :new isn't a variable of the
specified rowtype (I get PLS-00049: Bad bind variable).  Is there any way
at all to accomplish what I want to do?

Regards,
?yvind.



Sat, 08 Sep 2001 03:00:00 GMT
 Using :new and :old as parameters to Stored Proc

?yvind Pedersen

Quote:
> StoredProc(:new);

> This seems not to be allowed

Correct, you cannot do it. :New and :old are not really bind variables, but
are somehow handled at compile time. You cannot use them in any other way then
just :new.comn_name etc.

Arjan.



Sat, 08 Sep 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Stored Proc that finds difference in old vs new record

2. Using a stored proc to call another stored proc

3. Stored proc call with parameters using Execute SQL Task

4. Using parameters for Select Top in Stored Proc?

5. Stored Proc - Access table using Parameters

6. Passing Parameters to Stored Proc using ADO

7. How to call stored proc from ASP page and retrieve a Parameter from Proc

8. Passing old and new from trigger to proc.

9. Creating an update stored procedure with parameter of another stored proc

10. using stored proc results in other proc or select

11. Passing Parameters down to a buried view or stored procedure using parameters

12. Passing multiple parameters for a parameter using temporary stored procedures


 
Powered by phpBB® Forum Software