Re: doubt in sql

"Ramola" <j_ramola_at_yahoo.co.uk> wrote in message news:65c40e25.0109052207.6c6b0fa5_at_posting.google.com...
> hai..
> thanks a lot.. for ur reply...
> i tried this select statement
> select text from all_source where name='procedure_name';
> but it gives no rows selected...
> but this procedure has values ...if it has no
> values means my form won't work...
> regards
> ramola

The procedure name needs to be in uppercase or you need to use name = upper(procedure_name)
NB: *ALL* Oracle object names (be it a table name, index name or whatever) are *ALWAYS* in uppercase *ONLY*

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 06 2001 - 10:01:06 CDT