Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: interactive script prob
>>>>> "Andy" == Andy Khoo <andy.khoo_at_netcard.com.my> writes:
Andy> anyone out there could help me with this accept p_id prompt Andy> 'enter id:' delete from pat where pid = &p_id /
Andy> i get an error. wats wrong ?anyone? thx.
Geez, just a little bit of info would help - like what is the error you get?
You have not provided even the minimum of info necessary to even provide a guess, but I'll have a go.
If pid is a character field, you need to put &p_id in quotes. e.g. '%p_id'
-- Tim Cross The e-mail address on this message is FALSE (obviously!). My real e-mail is to a company in Australia called rapttech and my login is tcross - if you really need to send mail, you should be able to work it out!Received on Mon Mar 24 2003 - 02:12:06 CST