Bind a runtime variable in Select statement?

[jackiev]

I suspect this has a simple solution. Please help this SQL code newbie.

This select statement :

Select g.NOTIF_NAME, h.AW_NOTIF_EMAIL, g.NOTIF_ACTIVITY_DATE
from NOTIF g, NOTIF_DETAIL h
where g.aw_notif_seq = h.aw_notif_seq
and h.AW_NOTIF_EMAIL like '&email'
order by 1,2

gives me error:
ORA-01008: not all variables bound

How do I BIND this runtime parameter?

 

[feherke]

Hi

[ul]
[li]Are you sure this is related to MySQL ? Looks like Oracle to me.[/li]
[li]Are you sure the error occurs in that statement ? I see no variable to bind there.[/li]
[li]Next time please post your code between [tt][ignore]

[/ignore][/tt] and [tt][ignore]

[/ignore][/tt] TGML tags. Its much readable that way.[/li]
[/ul]


Feherke.
feherke.ga

 

[SkipVought]

him

"ORA" is Oracle, You might try forum759.

You have a parameter: email

 

[jackiev]

Thanks for the help.
I will try the options you suggested.

 

[feherke]

Hi

You have a parameter: email

Oops. I completely forgot substitution variables. ( Mainly used bind variables and even that was long time ago. )

Then email should be defined somewhere before that [tt]select[/tt] statement :

define email = 'fake@example.com'

Feherke.
feherke.ga