Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> SQL Forms 3.0 and the Copy/Name_in procedure/functions

SQL Forms 3.0 and the Copy/Name_in procedure/functions

From: Larry W. Virden <lwv26_at_cas.org>
Date: Tue, 14 Apr 1992 15:16:55 GMT
Message-ID: <1992Apr14.152113.3243@cas.org>

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: lvirden
Received on Tue Apr 14 1992 - 10:16:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US