Re: Trouble with name_in function (re-post)

In article <dewey-110992125749_at_sebastian.centerline.com>, dewey_at_centerline.com (Devan F. Dewey) wrote [in part]:
> blk := :system.cursor_block;
> fld := blk || '.explination';
>
> >>> explination := name_in(name_in('fld'));
>
>
> I'm trying to put the value stored in the field :hotel.explination into the
> local variable explination.
>
> What am I doing wrong???

Try: explination := name_in(:system.cursor_block||'.explination');

The description of name_in() in the manual is confusing (to me at least). If you don't need any indirection, you can go:

     explination := :hotel.explination;

> BTW: I've been trying to e-mail this to ORACLE support. Does anyone have an
> e-mail address for them???

Wouldn't it be nice if they had an email address?

I hope you had a good reason for the spelling of that variable because it's exacerbating my neurosis. Received on Mon Sep 14 1992 - 17:46:22 CEST