Re: Problem calling an Oracle stored procedure from SQR

[Raemil Billings <Gene.R.Billings@JCI.COM>]

All that sounds a little complicated for what you are trying to accomplish.
Would this work?

begin-sql

INSERT INTO LONGDESCRIPTION (LDKEY, LDOWNERTABLE, LDOWNERCOL)
VALUES ($dest_ldkey, $dest_table, $dest_column);

UPDATE LONGDESCRIPTION
SET LDTEXT = (SELECT L2.LDTEXT FROM LONGDESCRIPTION L2
                                WHERE L2.LDKEY = $source_ldkey
            AND L2.LDOWNERTABLE = $source_table
            AND L2.LDOWNERCOL = $source_column)
WHERE LONGDESCRIPTION.LDKEY = $dest_ldkey
AND LONGDESCRIPTION.LDOWNERTABLE = $dest_table
AND LONGDESCRIPTION.LDOWNERCOL = $dest_column;

end-sql

Hope this helps,

====================================
Raemil Billings
Systems Engineer
Johnson Controls
321-784-7796