Re: Problem calling an Oracle stored procedure from SQR

[Bill Smith <whsmith@SRPNET.COM>]

Raemil - We tried this approach, but Oracle doesn't allow a long datatype
column to be selected as part of a subquery.
Thanks for the suggestion, though!



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