| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> SQL Forms 3.0 and the Copy/Name_in procedure/functions
I have a series of blocks in a form which have the same field names within each.
I would like to write a procedure which, when given the name of a block as an argument, would perform some action on the fields in that block.
What I am trying to do is something like:
procedure tst_cp (blk in char) is
begin
copy(':' || name_in(blk) || '.par_id', :global.par_id); end ;
and then I want to call this procedure as:
tst_cp('junk');
so that :junk.par_id is copyed into the global variable par_id.
The problem is that when I get to the copy statement, I get an Undefined field or variable reference error from Sql Forms 3.0 .
Anyone have any ideas on what I might be doing wrong here?
I tried changing the above to :
procedure tst_cp is
begin
copy(':" || name_in(:global.blk) || '.par_id', :global.par_id); end;
and then
:global.blk := 'junk';
tst_cp;
and got the same results.
-- Larry W. Virden UUCP: osu-cis!chemabs!lvirden Same Mbox: BITNET: lwv26_at_cas INET: lvirden_at_cas.org Personal: 674 Falls Place, Reynoldsburg,OH 43068-1614 America Online: lvirdenReceived on Tue Apr 14 1992 - 10:16:55 CDT
![]() |
![]() |