Triggers & (Where-)Parameters

I'm using some Paramters for select clause (P_WhereXX with default value '1=1', and at runtime I set the parameter to sth. like fieldname = 'abc').

Now, I'd like to use this parameter in a (after report-)trigger, or even better the complete SQL-Clause of by DataGroup: I have to delete some records which have been printed out.

How can I use these parameters? In the trigger on compilation I get diferent errors:

PL/SQL-Clause:

function afterreport...

[...] select [...] where (P_WhereXXX) -> error -> 'identifier P_WhereXXX
must be declared'

[...] select [...] where (:P_WhereXXX) -> error -> 'expression is of wrong
type' (????)

[...] select [...] where (&P_WhereXXX) (like in my normal SQL-DataGroup) ->
error -> 'encountered '&' when excepting' one the following [...]

Can anyone give me some hints?

Thanks & regards,

F. Schmitt Received on Wed Apr 07 1999 - 09:10:17 CEST