Re: INSERT DYNAMIC SQL DOESNT GET VALUES
Only you have your tables, so only you can debug your sproc. All I can understand is its logic, which seems to be to generate an insert statement from two tables of yours.
The sproc returns column names because the VALUES argument is a quoted list of column names. It's doing what it's been told to do.
SQL is by design a very limited computer language, eg it doesn't do variable substitution except in specific ways. To see how to run dynamic queries, see the manual page for PREPARE.
Subject
Views
Written By
Posted
1525
May 15, 2018 12:17AM
Re: INSERT DYNAMIC SQL DOESNT GET VALUES
636
May 15, 2018 02:56PM
617
June 05, 2018 12:01PM
646
June 05, 2018 01:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.